Zoho Banner September 2011

Powershell one-liner for gathering mailbox stats

Posted January 17, 2010

 

The Get-MailboxStatistics cmdlet is great for showing a range of detailed information about the mailboxes in your organisation.  Sometimes you need to pare down the information to just the really useful stuff (such as mailbox size, item count, etc.) and push it to a CSV file.  Here’s one that I find helpful:

 


get-exchangeserver | where-object {$_.IsMailboxServer -eq $true } | `

Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | `

Select-Object DisplayName,@{label="TotalItemSize(MB)";`

expression={$_.TotalItemSize.Value.ToMB()}},`

ItemCount,ServerName,StorageGroupName,DatabaseName | `

export-csv c:\stats.csv –NoTypeInformation

4 Comments so far

  1. Daniel ODonnell on January 29th, 2010

    Hi,

    This looks really usefulbut I am unable to use the script as I get the following error:

    Select-Object : Illegal key label
    At line:3 char:14
    Select-Object <<<< DisplayName,@{label=”TotalItemSize(MB)”;`

    I am using powershell v1 with 2008 64 Bit Server.

    Thanks

    Daniel

  2. Tony Murray on January 31st, 2010

    Hi Daniel

    It might be that the formatting has changed after copy/paste from the web site. I’ve just tried it and it works for me, but in the past I have seen situations where characters like double-quotes get transformed. Try replacing the special characters in that line manually and see if it works.

    Tony

  3. ebuford on May 28th, 2010

    This really is a great script.
    Thanks for taking the time to post it!

  4. www.zhengda.me on July 27th, 2010

    when i changed the “lable” to “name”,it works.
    look below:
    @{name=”TotalItemSize(MB)”;`

    or not it will report “Illegal key label”

    I am also using powershell v1 with 2008 64 Bit Server.

    Thanks

    chander

Leave a reply