Exchange 2010 – Average message size and similar reports

I needed to report avarage message size in Exchange 2010 environment.

In my case was acceptable to get this value by the following command:

Get-TransportServer | Get-MessageTrackingLog -resultsize unlimited | measure-object -Property TotalBytes -Maximum –Average

Count    : 3673572
Average  : 180381.180685447
Maximum  : 31447136
Property : TotalBytes

Of course that mentioned way cannot be handy for all scenarios. Here is a brief list of available methods which give us ability to report more than avarage message size based upon Message Tracking Logs.

  • Log Parser Studio – Log Parser Studio is a utility that allows you to search through and create reports from your IIS, Event, EXADB and others types of logs. It builds on top of Log Parser 2.2 and has a full user interface for easy creation and management of related SQL queries. (Introducing: Log Parser Studio)
  • Exchange 2007/2010 Email stats – Analyzes Exchange 2007 or 2010 Message Tracking Logs and produces a .csv file of mail stats per user, and keeps distribution list usage.  As posted, it will find all the HT servers in the organizaions, retrieve the logs from the previous day, and generate stats for each user, by primary smtp address, for: Total Messages and Bytes Sent, Unique Messages and Bytes Sent, Total Messages and Bytes Received, both Internal and External emails.
  • Microsoft Exchange Server Profile Analyzer (64 bit) – Use the Microsoft Exchange Server Profile Analyzer tool to collect estimated statistical information from a single mailbox store or across an Exchange Server organization. The collected data can be used for such tasks as analyzing the performance and health of a server that has mailboxes, improving capacity planning models, and improving testing methodologies and tools.

Exchange 2010 – OWA – Browser is not automatically redirected

If you have configured OWA redirect in my case through TMG (Setting up an OWA Redirect in Forefront TMG 2010), you will see the following notification for a while:

05-05-2013 20-41-22

Your browser will be automatically redirected. 
If your browser does not support automatic redirection, browse to the original URL again.

If your browser does not support automatic redirection, you will see ONLY the notification despite of successful authentication.

How to enable automatic redirection:

  1. Open Internet Explorer or Control Panel
  2. Internet Options
  3. Click the “Security” tab and click the “Custom Level” button
  4. Click the “Enable” radio button underneath the “Allow META REFRESH” header.
  5. Close and reopen browser to finish enabling automatic redirect.