How to check Mailbox Statistics from PowerShell in Exchange Server 2007

Below command will display very limited information of users like list of mailboxes, storage limit status and last logon time.

Get-MailboxStatistics

 

This command display detail report of mailboxes

Get-MailboxStatistics | fl

 

This command display the list of mailboxes with their mailbox size (in bytes)

Get-MailboxStatistics | ft DisplayName,TotalItemSize,ItemCount

Get-MailboxStatistics | Sort-Object TotalItemSize “Descending | ft DisplayName,TotalItemSize,ItemCount

I am going to display the mailbox sizes in kilobytes.

Get-MailboxStatistics | Sort-Object TotalItemSize “Descending | ft DisplayName,@{ expression={$_.TotalItemSize.Value.ToKB()}},ItemCount

Same as above but column name will be better:-

Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(KB)";expression={$_.TotalItemSize.Value.ToKB()}},ItemCount