1

This report can be run as a scheduled task on an Exchange server. Incredibly customizable, so if there’s something that you’d like to see in the report just ask.

This will get mailbox statistics and export to CSV. You can change the CSV location at the end.

Get-MailboxStatistics | where {$_.ObjectClass -eq "Mailbox"} | Sort-Object TotalItemSize -Descending | ft @{label="Users";expression={$_.DisplayName}}, @{label="Total Mailbox Size (MB)";expression={$_.TotalItemSize.Value.ToMB()}}, @{label="Number of Items";expression={$_.ItemCount}}, @{label="Storage Limit";expression={$_.StorageLimitStatus}} | export-csv c:\MailboxStats.csv

I’ll add emailing this directly from Powershell in a subsequent topic.

1 Spice up