Tuesday 5 June 2012

User Mailbox Statistics report from Exchange Server


Oh PowerShell How I love you!!, Believe me, the below single command line can get the User Mailbox Statistics report from exchange servers.


User Mailbox Statistics report Storage Wise from Exchange Management Shell


Get-MailboxStatistics -server <exchange server Name> | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},storagegroupname,servername> c:\result.txt
 

User Mailbox Statistics report OU base from exchange Shell

Get-Mailbox –OrganizationalUnit "contoso.com/Users/Students" | Get-MailboxStatistics | Sort-Object TotalItemSize-Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},storagegroupname,servername >c:\result.txt




PowerShell just rocks, isn't it!!!!

1 comment:

  1. Very Resourceful! , it provides the script to generate the user mailbox statistics report on exchange server. I found the good utility named Lepide Exchange Reporter (
    http://www.lepide.com/exchange-reporter/ ) that provides the facilitate to generates exchange mailbox size reports and other information related to user mailboxes and helps to identify over sized user mailboxes.

    ReplyDelete