Viewing mailbox sizes in Exchange 2007

Go To Start -> Microsoft Echange Server 2007 -> Exchange Management Shell

Then, copy/paste the following cmdlet:

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