The ability to gather mailbox information in Exchange 2007 and 2010 was vastly improved via Powershell.\u00a0 As Exchange engineers we’ve been tasked with retrieving various informational reports on user mailboxes. The scripts you will find\u00a0below were created specifically for this purpose.<\/p>\n
In the example script below we’ve split reporting out into 2 categories. In the first one we pull information on all mailboxes where “customattribute7” does not contain the word exempt. This script gathers a user’s display name , total item counts per mailbox, and overall mailbox size. It converts the mailbox size information into MB format and finally puts the information into a text file located on our file server.<\/p>\n
Get-Mailbox | where { $_.customattribute7 -ne “exempt” } | Get-MailboxStatistics | select displayname, itemcount, TotalItemSize | sort-object totalitemsize -descending | format-table displayname, itemcount, @{expression= {$_.TotalItemSize.value.ToMB()};label=”TotalItemSize(MB)”} -Auto > “\\\\fileserver\\reports\\mailboxinfo.txt<\/a>”<\/p>\n Example Output:<\/strong><\/p>\n DisplayName\u00a0\u00a0\u00a0\u00a0 ItemCount\u00a0\u00a0\u00a0\u00a0 TotalItemSize(MB)<\/strong><\/p>\n Test,\u00a0User\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32327\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1437<\/strong><\/p>\n The second script performs exactly the same function except it will report on only users where “customattribute7” contains the word exempt<\/p>\n Get-Mailbox | where { $_.customattribute7 -eq “exempt” } | Get-MailboxStatistics | select displayname, itemcount, TotalItemSize | sort-object totalitemsize -descending | format-table displayname, itemcount, @{expression= {$_.TotalItemSize.value.ToMB()};label=”TotalItemSize(MB)”} -Auto > “\\\\fileserver\\reports\\mailboxinfo.txt<\/a>”<\/p>\n More Mailbox Information commands will be posted shortly<\/p>\n The ability to gather mailbox information in Exchange 2007 and 2010 was vastly improved via Powershell.\u00a0 As Exchange engineers we’ve been tasked with retrieving various informational reports on user mailboxes. The scripts you will find\u00a0below were created specifically for this … Continue reading