Collect/Report Exchange Statistics

Posted on 2006-04-26
Last Modified: 2012-05-05
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.
Question by:peter_field
    LVL 104

    Accepted Solution

    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.

    LVL 4

    Author Comment

    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.

    LVL 104

    Expert Comment

    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.

    LVL 4

    Author Comment

    Thanks for all your help.



    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
    Set OWA language and time zone in Exchange for individuals, all users or per database.
    In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
    In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now