Admin client - how to tell how many e-mail messages sent & received within a certain time frame?

Notes 8.0.2 clientDomino 8.5.1 server - Used almost exclusively for e-mail only.

Is there any way, from the Administrator client, of telling how many e-mail messages were sent and how many were received within a certain time frame? I think I may be missing a setting. Thank you.

Subject: Reports.nsf

Search the Admin Help for ‘Tools for mail monitoring’ - about the only ‘built in’ tool is the Reports.nsf database -

It’s helpful but not 100% accurate.

Subject: reports.nsf

I have setup the reports.nsf with a daily report that collects message volume for “today” and I changed the time that the daily agent runs from 12:00am to 11:59pm, now I can get message volume by hour for the previous day.I have had a bit of trouble getting it to run nightly for some reason that I am still working on.

My next task is; I need to extract the data from reports.nsf into a sql database. Does anyone have any experience with “Lotus Notes SQL Driver” and the reports.nsf database specifically?

Subject: reports.nsf

Found that since the daily agent takes longer than one minute to run, if I started it a 11:59pm it runs into the next day, then it detects that it ran that day and does not run that night, so it then ran every second day, ( makes sense now :wink: I changed it to run at 11:30pm, now I get a daily “hourly volume” report.

I still need to get it into SQL somehow.

Subject: message tracking or show stat mail

Another way would be to use message tracking.

Sent = From mydomain.com to (blank) then put in whatever time ranges most closely matches.

Received = From (blank) To mydomain.com then put in whatever time ranges most closely matches.

When you get the results, copy/paste them into a spreadsheet, remove the report header, and the row numbers will tell you how many entries.

If you want to dial in the times more closely, this is already in time order, so remove entries from the top and bottom and then count the rows.

Another tool is Do a show stat mail on the console. This will give you all kinds of stats, but the timeframe is “last time the server was started to now”. So, this is more useful if you capture it over time, and then compare the numbers within several timeframes to get your growth patterns.