List of exchange 2007 mailbox sizes

matthewwardle2754 · 2012-08-17T04:52:16.000Z

Hi guys i am looking for the easiest way to list of all the mailbox sizes for the users. My reports for spiceworks dont seem to work. I would prefer to do it through command prompt to text file or csv.

Thanks

Huw3481 · 2012-08-17T04:55:46.000Z

You need to make a slight change for Spiceworks to work properly with Ex2007/2010

See http://community.spiceworks.com/help/Exchange_2007

matthewwardle2754 · 2012-08-17T05:02:38.000Z

just looking at the requirements i dont have exchange server 2007 service pack 2. i am upgrading to exchange 2010 and need the mailbox sizes before i do this.

rockn · 2012-08-17T05:19:22.000Z

Have you looked through the scripts on the site here? Three are quite a few.

Huw3481 · 2012-08-17T05:21:19.000Z

Well, if you don’t fancy making any changes then you’re in to running Powershell cmdlets manually yourself.

Get-MailboxStatistics | ft DisplayName,TotalItemSize,ItemCount should give you total mailbox size and number of items.

There’s some nice detail in this article - http://www.msexchange.org/articles_tutorials/exchange-server-2007/management-administration/getting-mailbox-statistics-exchange-2007.html

jay6111 · 2012-08-17T06:41:47.000Z

Quick and dirty on Exchange in the management shell,

Mailbox size sorted by largest exported to txt file
Get-MailboxDatabase “<insert database name or don’t enter one for all DB’s>” | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount (optional | Select –first 25) >> C:*name_of_file*.txt

-Jay

matthewwardle2754 · 2012-08-17T06:44:58.000Z

jay do have to put the database name and i seem to get this error when i do it to file

jay6111 · 2012-08-17T06:50:11.000Z

You can, it appears by not entering a name and which the code then goes to check all of them it inadvertently picked a DB you have that is not mounted. So you would either need to mount that DB first or specify a DB.

-Jay

markmcfarlane3046 · 2012-08-17T07:09:40.000Z

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

newwave · 2016-09-14T18:21:58.000Z

This worked a bit better for me FWIW.

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

Leave off the last bit if you want it to display on the screen instead of output to a file

C:\Temp\MailboxSize.txt