Routing Statistics

HCL Domino Domino Forum
1

We have about a dozen servers across Europe. We are thinking of getting rid of some of these servers, without causing too much extra network traffic.

I would like to be able to see how many messages users send to someone on THEIR server, and how many to people on other servers or on the internet. If, for example 90% of all messages that are routed by a server stay on that server, then we should not replace it. If only 10% is sent to users on the same server, then we should definitely remove the server.

I looked at the reports-database, but I can’t seem to find a report that shows this…

Any ideas?

Thanks in advance,

Remco

2

Subject: Routing Statistics

I made a database wich collect mtstore data and generate an excel file. You may download it from http://www.bruere.com it is fully customisable with @formula and Excel

here it is the description of this freeware :

This is a freeware database allowing automatic generation of Excel graph based on domino routers statistics

Message Tracking must be enabled on some or all the Domino servers. Reports Definition provided may be customized, created. Then scheduled agents can be enabled.

The ERRS will process Report Definition one by one, it will collect required informations from MessageTracking databases, then it will update the Excel template provided into the report Definition Document, and a document will be created (Report-Processed document) containing the new updated Excel document.

3

Subject: Routing Statistics

You need to look at the mailbydest statistic which will give you the quantity routed to each server including $localdelivery since the last router restart.

4

Subject: RE: Routing Statistics

Mail.Delivered = # of local mailMail.Transferred = # of mail sent from one server to another

5

Subject: RE: Routing Statistics

Thanks for the replies. I’ll give the mailbydest thing a try, I’m waiting for the stats to come in now…(you have to turn it on by the way by typing set config RouterEnableMailByDest=1 at the console)

David, I assume Mail.Delivered also includes mail that came from other servers and not just the local server.

Remco

6

Subject: RE: Routing Statistics

ok, so now I see this (see below).

What is the difference between TotalRouted and Transferred?

And $LocalDelivery is mail from personA/Server1 to personB/Server1 right?

Thanks again,

Remco

MailByDest.CN=COMPFRANCE01/OU=SERVERS/O=COMP.LastSuccess = 10/08/2003 15:08:29 CEDT

MailByDest.CN=COMPFRANCE01/OU=SERVERS/O=COMP.TotalKBTransferred = 33

MailByDest.CN=COMPFRANCE01/OU=SERVERS/O=COMP.TotalRouted = 3

MailByDest.CN=COMPFRANCE01/OU=SERVERS/O=COMP.Transferred = 3

MailByDest.CN=COMPINTERNATIONAL01/OU=SERVERS/O=COMP.LastSuccess = 10/08/2003 15:12:27 CEDT

MailByDest.CN=COMPINTERNATIONAL01/OU=SERVERS/O=COMP.TotalKBTransferred = 790

MailByDest.CN=COMPINTERNATIONAL01/OU=SERVERS/O=COMP.TotalRouted = 7

MailByDest.CN=COMPINTERNATIONAL01/OU=SERVERS/O=COMP.Transferred = 4

MailByDest.CN=COMPSMTP01/OU=SERVERS/O=COMP.LastSuccess = 10/08/2003 15:12:21 CEDT

MailByDest.CN=COMPSMTP01/OU=SERVERS/O=COMP.TotalKBTransferred = 273

MailByDest.CN=COMPSMTP01/OU=SERVERS/O=COMP.TotalRouted = 5

MailByDest.CN=COMPSMTP01/OU=SERVERS/O=COMP.Transferred = 5

MailByDest.CN=COMPSMTP02/OU=SERVERS/O=COMP.LastSuccess = 10/08/2003 15:09:35 CEDT

MailByDest.CN=COMPSMTP02/OU=SERVERS/O=COMP.TotalKBTransferred = 7

MailByDest.CN=COMPSMTP02/OU=SERVERS/O=COMP.TotalRouted = 5

MailByDest.CN=COMPSMTP02/OU=SERVERS/O=COMP.Transferred = 2

MailByDest.CN=COMPSPAIN01/OU=SERVERS/O=COMP.LastSuccess = 10/08/2003 15:07:33 CEDT

MailByDest.CN=COMPSPAIN01/OU=SERVERS/O=COMP.TotalKBTransferred = 25

MailByDest.CN=COMPSPAIN01/OU=SERVERS/O=COMP.TotalRouted = 1

MailByDest.CN=COMPSPAIN01/OU=SERVERS/O=COMP.Transferred = 1

MailByDest.CN=COMPUK01/OU=SERVERS/O=COMP.LastSuccess = 10/08/2003 15:08:56 CEDT

MailByDest.CN=COMPUK01/OU=SERVERS/O=COMP.TotalKBTransferred = 32

MailByDest.CN=COMPUK01/OU=SERVERS/O=COMP.TotalRouted = 1

MailByDest.CN=COMPUK01/OU=SERVERS/O=COMP.Transferred = 1

MailByDest.[$LocalDelivery].Delivered = 44

MailByDest.[$LocalDelivery].LastSuccess = 10/08/2003 15:12:27 CEDT

MailByDest.[$LocalDelivery].TotalRouted = 44

7

Subject: RE: Routing Statistics

Just noticed that this has been asked a million times before, so here’s the answer:http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/75038bd613287ea385256d810031c166?OpenDocument&Highlight=0,totalrouted

I’ll stop this conversation with myself now.

Bye