Here is a nice little script I wrote to dump out data from both get-mailbox and get-mailboxstatistics. if you are in a mixed environemnt this script can be modified to report on only the exchange 2007/2010 mailboxes by modifing the get-mailbox section of the script. This script can dump the data to the screen or a csv file by changing the last line of code use either |FT or export-csv -path c:\Exports\MailData.csv
$results = @()
foreach($mbx in Get-Mailbox){$results +=Get-MailboxStatistics $mbx.identity | select @{n=”DisplayName”;e={$mbx.displayName}},@{n=”Hide From GAL”;e={$mbx.HiddenFromAddressListsEnabled}},@{n=”PrimarySMTPAddress”;e={$mbx.PrimarySMTPAddress}},@{n=”Forwarding Address”;e={$mbx.ForwardingAddress}},servername,database,itemcount,TotalItemsize}
$results | FT
Tweet