SBS 2011 (Exchange 2010) Mailbox Sizes

I am running out of disk space. I tried changing the view in ESM and add a column to reflect mailbox size but showing mailbox size isn't a column. How can I see all the mailbox sizes in one swoop to tell who the big offenders are?
LVL 15
LockDown32OwnerAsked:
Who is Participating?
 
IvanSystem EngineerCommented:
Hi,

run this command from exchange shell.

Get-MailboxDatabase "<database_name>" | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount

More on this can be found at: http://exchangeserverpro.com/browsing-mailbox-databases-in-exchange-2007-and-2010/

PS: Take a look at IIS logs, since they can eat a lot of space. They are usually at C:\inetpub\logs\logfiles\

Regards,
Ivan.
1
 
Todd NelsonSystems EngineerCommented:
Run this command to export a list of all mailboxes, sorted by size, to a CSV file...

Get-Mailbox | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount | Export-Csv C:\MailboxSizes.csv -NoTypeInformation

Open in new window


Take a look at the application log for Event ID 1221. They will tell you how much white space is available in the database(s); or you can run this command to see available space within the database(s)...

Get-MailboxDatabase -Status | ft -auto Name,DatabaseSize,AvailableNewMailboxSpace

Open in new window

0
 
Niten KumarPrincipal Systems AdministratorCommented:
Try running the following powershell script.  It will export data to a csv file(which can opened in excel and analyzed properly) sorting out mailbox size from biggest to lowest.

Get-MailboxStatistics -Database "XXXXXXXXXXX" | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending | Export-CSV C:\size\XXXXXXXXXXX.csv

XXXXXXXXXXX -  is the database name.
size is a folder which you can create in the c drive to save the exported csv file.
0
 
Cris HannaCommented:
Since you are running SBS 2011,  are you looking at the detailed report?   Mailbox sizes for all users are listed there.   Have you run the wizards to move the exchange mailbox database to another drive?   You can do the same for WSUS repository and other items
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.