Getting Database counts per Exchange Server via PowerShell

Was recently asked to generate a report of the total count of items per Exchange database per server. This one-liner (broken up for readability), takes care of it.

Get-MailboxServer | Get-MailboxStatistics | `
Sort-Object DatabaseName | `
Select DatabaseName, ItemCount | `
Group-Object -Property DatabaseName | `
Foreach {            
    $items = ($_.Group | Measure-Object -Property ItemCount -sum).Sum            
    "{0}`t{1:N0}" -f $_.Name,$items             
}

This will generate something like the following:

Exchange01-DB01	1,372,127
Exchange01-DB02	1,522,356
Exchange01-DB03	1,406,486
Exchange01-DB04	1,345,962
Exchange01-DB05	1,330,690
Exchange01-DB06	1,392,853
Exchange01-DB07	1,318,130
.....	.....

Enjoy!