Too many problems, not enough time.

Dude, Where’s my mail statistics?

One thing that really bugged me when Exchange 2007 was released was the removal in the GUI to view mailbox size and total items. I can’t figure out why? Though I’m sure there is something written in 3pt text in an obscure TechNet article somewhere?!?!

In Exchange 2000/3 you would drilled down to your Storage Group / Mailbox Store / Mailboxes. In Exchange 2007/10 it just doesn’t exist. So how to you get this information? PowerShell to the rescue… again. Just another clear indicator that Microsoft wants us using PowerShell more and more. Using Get-MailboxStatistics we can retrieve this basic information and so much more.

Get-MailboxStatistics

Running the Cmdlet by itself without any parameters will list DisplayName, ItemCount, and StorageLimitStatus for all mailboxes.

We can narrow it down to one user by using the following script.

Get-MailboxStatistics –identity “test.user”

If we want to replicate something similar to what we got in Exchange 2000/3 we can use the following script

There are a few things we can now do to clean up our report. TotalItemSize is returned to us in Bytes –not very user friendly. So we can convert this to MB. We can also sort our results by this column as well.

So now we have something very similar like the old Exchange System Manager would have provided us on the screen. In those days we would simply right click on our Mailbox container and select Export. We can easily achieve the same thing with PowerShell. Many people just redirect this output to a text file –which is fine. The better way is to pipe it to a CSV file