Not the prettiest thing in the world but gets the job done by printing each user's mailbox size & total items into a HTML table:
get-mailbox -database "Mailbox Database 1706745955" | get-mailboxstatistics | where {$_.objectclass -eq "Mailbox"} | sort-object totalitemsize -descending | select-object @{label="User";expression={$_.DisplayName}},@{label=
"Total Size (MB)";expression={$_.TotalItemSize.Value.ToMB()}},@{label="Items";expression={$_.ItemCount}} | convertto-html | out-file report.htm
May need to modify the mailbox database name.
Have a look to this
ReplyDeletehttp://ammarhasayen.wordpress.com/2013/09/24/the-most-amazing-exchange-2010-dashboard-report-script-monitor/
More advance report. One if the best out there.
It is full dashboard for Exchange health
Nice PowerShell Script, this Get-Mailbox cmdlet to show mailbox objects and attributes, or to supply mailbox information to other related tasks . I found good software from http://www.lepide.com/exchange-reporter/ which helps to generate report on users mailboxes on an exchange server and reoport on the mailbox size, number of messages the dates on the messages, sizes of the specific folders and a report of size and total number of attached files.
ReplyDelete