If you’ve recently upgraded to Exchange 2007, you may have noticed that Exchange 2003 is missing two really useful columns: Size and Total Items! Personally, this annoyed me a lot because it was a great way to quickly see which Exchange users are taking up the most space on the server.
Worst of all, the columns don’t appear even when you navigate to the Add / Remove Columns dialog in Exchange.
So how do you know the size of a user’s mailbox in Exchange 2007? Well, until they return columns in a future service pack, you’ll have to use the command line.
For example, here’s a command line that you could use to get a list of all mailboxes with their sizes sorted from largest to smallest. It will also give you the number of items in the mailbox and list the sizes in MB.
Get-MailboxStatistics | Sort-Object TotalItemSize-Descending | ft DisplayName, @ {label = “TotalItemSize (MB)”; expression = {$ _. TotalItemSize.Value.ToMB ()}}, ItemCount
If the above command doesn’t work for any reason, you can also try this one:
– / Get-MailboxStatistics -Database Mailbox Database | Sort -Properties TotalItemsize | Format-Table DisplayName, LastLoggedOnUserAccount, ItemCount, @ {expression = {$ _. Totalitemsize.value.ToMB ()}; label = “Size (MB)”}, LastLogonTime, LastLogoffTime
Note, if you just want to see the size of a single mailbox, you can simply go to Mailbox Properties and view the size and item count in the General tab.
The final way to access this information is to install the Exchange 2003 management tools on a different server and use them to view Exchange 2007 mailbox sizes. Do not use the tool to perform any management tasks, just view mailbox information.
Hopefully future versions or service packs of Exchange 2007 fix this problem, but for now you can use the command line or the Exchange 2003 management tools! Enjoy!
–