One of the most frequently used Exchange 2003 mailbox management administrative features was the mailbox size, total item count, last logon time, log off time etc. For some strange reason, this convenient feature has been left out of Exchange Server 2007. If you are reading this blog then you probably are looking for a way to get these stats back.

The Exchange 2007 power shell is power packed to deal with this drawback and you can get all the info you need (displayed just like ESM 2003) in a jiffy by running this command (you will need to substitute MailboxServer01 with your server name):

Get-MailboxStatistics -Server MailboxServer01 | Sort -Property TotalItemsize | Format-Table DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label=”Size(MB)”}, LastLogonTime, LastLogoffTime | Export-CSV ExMBXInfo.csv

All this info would get written to a csv file with the filename ExMBXInfo.csv (Edit the file name in the command if you want to call it something else)

The variables used here are DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime. There are a host of other variables that can be used to get more information. Here are some of these variables that can be used:

AssociatedItemCount
Database
DatabaseName
DeletedItemCount
DisconnectDate
DisplayName
Identity
ItemCount
LastLoggedOnUserAccount
LastLogoffTime
LastLogonTime
LegacyDN
MailboxGuid
ServerName
StorageGroupName
StorageLimitStatus
TotalDeletedItemSize
TotalItemSize

Drop me a line if this article helped you!