Exchange 2007 - Mailbox Statistics

This will output Mailbox Statistics for all users on Exchange2007 in MB.

• Get-MailboxStatistics -Server Servername | Sort -Property DisplayName | ft DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label="Mailbox Size(MB)"}, itemcount, lastlogontime, lastlogofftime,lastloggedonuseraccount 

Sort all mailboxes by size

• get-mailbox | Get-MailboxStatistics | Select @{n="DisplayName";e={$_.DisplayName}}, StorageGroupName,@{e={$_.TotalDeletedItemSize.Value.ToMB()};n="TotalDeletedItemsSize(MB)"}, DeletedItemCount, @{e={$_.TotalItemSize.Value.ToMB()};n="TotalItemSize(MB)"}, ItemCount, StorageLimitStatus | Sort-Object "TotalItemSize(MB)" | ft

Sort all mailboxes by "StorageLimitStatus"

• get-mailbox | Get-MailboxStatistics | where-object {$_.StorageLimitStatus -eq "NoChecking"} | Select @{n="DisplayName";e={$_.DisplayName}}, StorageGroupName,@{e={$_.TotalDeletedItemSize.Value.ToMB()};n="TotalDeletedItemsSize(MB)"}, DeletedItemCount, @{e={$_.TotalItemSize.Value.ToMB()};n="TotalItemSize(MB)"}, ItemCount, StorageLimitStatus | Sort-Object "TotalItemSize(MB)" | ft