Mailbox Size Report

Mailbox Size Report
Description
Script displays table with mailbox size statistics.
Usage
Run from Exchange Management Shell.
Sample Script
get-mailbox | get-mailboxstatistics | select-object DisplayName,TotalItemSize,StorageLimitStatus,LastLogonTime

Disclaimer: The sample scripts are meant to serve as examples and may need modifications before they will work in your environment. The authors of the script are not responsible for any negative outcome that may result from using them.

Another Sample
Get-MailboxStatistics -Database "mailbox database" | Sort -Property DisplayName | ft DisplayName, @{expression={$_.totalitemsize.value.ToMB()};label="Mailbox Size(MB)"}, itemcount, lastlogontime, lastlogofftime,lastloggedonuseraccount
This example get mailboxes from a mailbox database named "mailbox database", Output is sortet on DisplayName and the mailboxsize is displayed in MB

Comments
From hkok - 01/04/08 6.33
I think you just have to morph this. I got this running on Exchange 2007 just fine.
Get-Mailbox -server | get-mailboxstatistics | select-object DisplayName,@{expression={$_.TotalItemSize.value.ToKB()}},Itemcount,ServerName

The question I have is can we have a single script that works on both Exchange 2007 and 2003? It doesn't appear management on Exchange 2007 applies to 2003.
From evetsleep - 26/01/07 8.12
This actually doesnt produce a mailbox size report at all. It lists the DisplayName, ItemCount, StorageLimitStatus, and last LastLogonTime. A mailbox "size" report should return the actual size of the mailboxes:
get-mailbox | get-mailboxstatistics | select-object DisplayName,TotalItemSize,StorageLimitStatus,LastLogonTime
You could go further and format it, sort it, and even e-mail it (which I do).