Exchange 2010 Database Statistics with PowerShell

This morning I was asked to write a script that would email a daily report of Exchange 2010 database statistics. The customer wanted the following information about each database:

• Total database size
• Total number of mailboxes per database
• Average mailbox size
• Date and time of the last full backup
• Amount of white space in the database

Thanks to the improvements made to the Get-MailboxDatabase cmdlet in Exchange 2010, it's a lot easier to gather all of this information than it used to be. Here is the function I created to grab the info:

function Get-DatabaseStatistics {
    $Databases = Get-MailboxDatabase -Status
    foreach($Database in $Databases) {
        $DBSize = $Database.DatabaseSize
        $MBCount = @(Get-MailboxStatistics -Database $Database.Name).Count

        $MBAvg = Get-MailboxStatistics -Database $Database.Name |
          %{$_.TotalItemSize.value.ToMb()} |
            Measure-Object -Average            

        New-Object PSObject -Property @{
            Server = $Database.Server.Name
            DatabaseName = $Database.Name
            LastFullBackup = $Database.LastFullBackup
            MailboxCount = $MBCount
            "DatabaseSize (GB)" = $DBSize.ToGB()
            "AverageMailboxSize (MB)" = $MBAvg.Average
            "WhiteSpace (MB)" = $Database.AvailableNewMailboxSpace.ToMb()
        }
    }
}

Here is a screen shot running the above function in the Exchange Management Shell:

Using the Get-DatabaseStatistics function, it's easy to export the data to a csv:

Get-DatabaseStatistics | Export-Csv c:\windows\temp\report.csv -Force -NoType

And then send the report to the administrator in an email:

Send-MailMessage -To administrator@litware.internal -From powershell@litware.internal -Subject "Database Statistics for $((get-date).ToShortDateString())" -SmtpServer hc1 -Attachments c:\windows\temp\report.csv

I added all of this to a single script and configured a scheduled task so that it would email the customer daily.

Update 5/31/2011 - I updated the code for this function so that archive and disconnected mailboxes would be taken into consideration.

Related Posts

• Restoring Mailbox Data from a Recovery Database in Exchange 2010 SP1 (13)
• Quick Tip: How To Check Exchange Database Size with PowerShell (6)
• Generating Delivery Reports and Tracking Messages from PowerShell (1)
• Managing Exchange 2010 and Lync 2010 from a Single PowerShell Session (0)
• How to Generate an Exchange 2010 Room List Report with PowerShell (3)

Tagged as: Database, EMS, Exchange, PowerShell, Report, Statistics