MailboxStatistics Reports

I keep getting this simple question: "How can I find the list of attributes that I can use for a report on the Mailbox Statistics?"
 
The answer is simple, but I keep forgetting it. Simply pipe the results for a single user (Billy Bob, in the example) to a list, and it will provide the list of the attributes that can be used in a report.
 
get-mailboxstatistics "Billy Bob" | fl
 
 
RunspaceId              : a359ce6e-74c3-4936-8d0f-d782ad2146db
AssociatedItemCount     : 11
DeletedItemCount        : 0
DisconnectDate          :
DisplayName             : Billy Bob
ItemCount               : 0
LastLoggedOnUserAccount : IHELPbillyb
LastLogoffTime          : 4/5/2010 7:44:21 PM
LastLogonTime           : 4/5/2010 7:34:44 PM
LegacyDN                : /O=IHELP/OU=EXCHANGE ADMINISTRATIVE GROUP (FYDIBOHF23
                          SPDLT)/CN=RECIPIENTS/CN=BILLY BOB
MailboxGuid             : 7f088a15-c8b7-4745-87d3-78f86d364c2f
ObjectClass             : Mailbox
StorageLimitStatus      : BelowLimit
TotalDeletedItemSize    : 0 B (0 bytes)
TotalItemSize           : 4.385 KB (4,490 bytes)
Database                : Executives
ServerName              : EX1
DatabaseName            : Executives
MoveHistory             :
IsQuarantined           : False
IsArchiveMailbox        : False
Identity                : 7f088a15-c8b7-4745-87d3-78f86d364c2f
MapiIdentity            : 7f088a15-c8b7-4745-87d3-78f86d364c2f
OriginatingServer       : ex1.ihelp.com
IsValid                 : True
 
From the above list, you can then pull the information that you want in your report. For example:
 
Get-mailboxdatabase | Get-mailboxstatistics | ft DisplayName,TotalItemSize,ItemCount
 
The above command will get you something like this:
 
DisplayName                TotalItemSize                              ItemCount
———–                        ————-                                 ———
Microsoft Exchange         134 B (134 bytes)                                  1
SystemMailbox{d693      318 B (318 bytes)                                  1
Microsoft Exchange Ap   983 B (983 bytes)                                  1
Microsoft Exchange Ap   134 B (134 bytes)                                  1
SystemMailbox{9b268    571 B (571 bytes)                                  1
Billy Bob                         4.385 KB (4,490 bytes)                             0
Discovery Search Mai 61.46 KB (62,936 bytes)                            4
Jim Jones                               0 B (0 bytes)                                      0
SystemMailbox{1521c    318 B (318 bytes)                                  1
Administrator              58.34 KB (59,744 bytes)                            4
ConferenceRoom                 0 B (0 bytes)                                      0
SystemMailbox{2fc6476 318 B (318 bytes)                                  1
 
Advertisements
This entry was posted in Exchange. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s