Home > Exchange, Powershell > Exchange 2007/2010 mailflow statistics

Exchange 2007/2010 mailflow statistics

At one of our customer I was asked if there is any tool to make some statistics out of Exchange mailflow. You can use GUI Microsoft Exchange Tracking Log Explorer. This tool it usefull unless you need to make some smarter data handling. This tool doesn’t count how many mails user sent or received. Even those data displayed on the end are not exportable.

But you can create nice reports using Powershell cmdlet Get-MessageTrackingLog (http://technet.microsoft.com/en-us/library/aa997573.aspx).

Let’s start from the basic. We just want to see who send an e-mail and to whom since 6th of September 2011:

Get-MessageTrackingLog -EventID “SEND”  -Start “09/06/2011 11:10AM” | fl Sender, Recipients, Timestamp, MessageSubject

When you want same numbers, but about receiving mail you use:

Get-MessageTrackingLog -EventID “RECEIVE”  -Start “09/06/2011 11:10AM” | fl Sender, Recipients, Timestamp, MessageSubject

This is simple. Let’s look of table of people who does SEND most:

Get-MessageTrackingLog -EventID “SEND”  -Start “09/06/2011 11:10AM” | Group -Property Sender | Sort -Descending -Property Count

Using cmdlet Export-csv (http://technet.microsoft.com/en-us/library/dd347724.aspx) you can export result into CSV and you can work with it in Excel if you like.

I think Exchange is missing such a tool to provide complex view on mail infrastructure, but let’s hope they will include in next version 🙂

  1. No comments yet.
  1. No trackbacks yet.