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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.