Generate HTML Reports in Exchange 2007

It is now easy to produce HTML reports with Exchange 2007 automatically with the task scheduler, and have them published to a web directory.

The follwing command would produce a HTML report of mailbox statistics, as seen below, but could include anything that can be scripted in powershell.

Get-MailboxStatistics | Select DisplayName, ItemCount | Sort ItemCount | ConvertTo-HTML –Property DisplayName, ItemCount >C:\report.htm

This can be enhanced with some css styles easily with the scripts from Scriptacular


In order to install Scriptacular just download the zip file from Vivek’s web site and extract all the content into the Scripts folders of the Exchange Server 2007 installation path. If you installed Exchange Server using the default settings it should be at c:\program files\Microsoft\Exchange Server\Scripts folder.

We are going to work with the script: out-html.ps1 This can be used with an extra | (pipe) at the end of any PowerShell commandlet, and generates the output in HTML format with css styles.

To improve the output format using Scriptacular just add the following extra commands:

Get-MailboxStatistics | select DisplayName,ItemCount | out-html | out-ie

As you can see the format of the HTML is much nicer.