Friday, July 1, 2011

Exchange 2010 HTML Mailbox Size Report

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.

2 comments:

  1. Have a look to this
    http://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

    ReplyDelete
  2. 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