How can I get the number of mailboxes,size of mailboxes (average,total) and growth per year? We are using Exchange 2007

195 pts.
Tags:
Exchange 2007 databases
How can I get the number of mailboxes,size of mailboxes (average,total) and growth per year? We are using Exchange 2007.
 
 
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

command line you would use to get a list of all mailboxes with their sizes sorted from biggest to smallest. It will also give you the number of items in the mailbox and will list the sizes in MB.

Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label=”TotalItemSize(MB)”;expression={$_.TotalItemSize.Value.ToMB()}},ItemCount

If the above command does not work for some reason, you can also try this one:

Get-MailboxStatistics -Database “Mailbox Database” | Sort -Property TotalItemsize | Format-Table DisplayName, LastLoggedOnUserAccount, ItemCount, @{expression={$_.totalitemsize.value.ToMB()};label=”Size(MB)”}, LastLogonTime, LastLogoffTime

Note that if you just want to see the mailbox size of one mailbox, you can simply go to the Properties of the mailbox and view the size and number of items on the General tab.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Shieldwolf
    Thank you very much Christina. I tried your command line and it works. But what if I want to save it via csv file? I tried this command: Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount| Export-CSV "C:\ExchangeSetuplogs\Mailboxsize.csv". But when I open the file, I can see only numbers and letters. Thanks a lot.
    195 pointsBadges:
    report
  • Shieldwolf
    And how can I get the estimated Growth Per Year?
    195 pointsBadges:
    report
  • Shieldwolf
    I got the answer now and I would like to share it as well: Get-MailboxStatistics –Server "Server" | Sort-Object TotalItemSize -Descending | select-object DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount| Export-CSV "C:\ExchangeSetuplogs\Mailboxsize.csv"

    195 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: