Collect/Report Exchange Statistics

We need to be able to collect Exchange statistics like the number of emails an indervidual has sent/recieved, mailbox sizes, mailbox quota stats, total email the server has sent/recieved and if possible spam stats also (i.e. IMF, Sender ID and Connection Filter stats) within a specific time period.

The requirement is we dont want to install a software package (we are an IT company that looks after a number of servers - and we prefer not to change the servers too much). We are looking for a package that can run without installation, or scripts to extract the data. No IIS pages or SQL databases. Just something simple that will report the data.

The collection period will always be from month back to the current date.

Any help please? Thanks guys.
Who is Participating?
Turn on Message Tracking. That will give you the raw information.

The market leader in this is Quest with their message stats product. That will give you more statistics than you can throw a stick at. It will not be live - as message tracking locks the files, so you have to wait until the next day for the information.

There are some other products that do a similar thing, or you could simply import the message tracking logs in to access and then manipulate from there. Take a look at the page above - I have linked to some of the resources.

peter_fieldAuthor Commented:
Excellent, thanks for pointing me in the right direction. The message tracking logs do exactly what I want, except for the spam stats, and mailbox size/quotas. I have already found a script to get the mailbox size/quotas.

Any ideas on how to get the spam stats out? All the info I want is in Performance Monitor, but I can't for the life of me get it out with WMI. I'm looking for these stats out of Performance Monitor:

MSExchange Intelligent Message Filter
   - Total UCE Messages Acted Upon
   - % UCE out of Total Messages Scanned

MSExchange Sender ID
   - Total Messages Validated by Sender ID
   - Total Messages Validated with a Fail - Non-existent Domain Result
   - Total Messages Validated with a Fail - Malformed Domain Result
   - Total Messages Validated with a Fail - Not Permitted Result

MSExchangeTransport Filter Sink
   - Block List DNS Queries Issued
   - Connections Rejected by Block List Providers
   - Failed Block List DNS Queries

Quest is too big, bulky and expensive for my liking. As are most of the 3rd party reporting packages.

I saw your other question that covered the scripting.
Unfortunately my scripting skills aren't too hot. I have a core of scripts that I have cobbled together and when I need something else I have another MVP who I ask and he knocks something up in about 30 minutes for me.

Have you looked the Scriptomatic2 tool from Microsoft, or the WMI Code Creator (another download from Microsoft). They might be able to do what you want.

peter_fieldAuthor Commented:
Thanks for all your help.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.