The following article describe how to create Mailboxes size report/s in Exchange 2010.
Step 1:
Open “Exchange Management Shell”.
Step 2:
Use one of the following commands:
To Check all the mailbox size with the no. of Items in mailbox with Send/Receive attachment size in a particular DB & export the report to CSV file, run below mentioned command in EMS;
[PS] C:\Windows\system32>Get-Mailbox -Database "Database Name" | sort-object | Select-Object name,alias,servername,Prohibi
tSendQuota,IssueWarningQuota,MaxReceiveSize,MaxSendSize,DisplayName,Database,PrimarySmtpAddress,ProhibitSendReceiveQuota
,@{n="Size(KB)";e = {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.totalItemsize}},@{n="Items"; e = {$MBXstat = Get
-MailboxStatistics $_.name ; $MBXstat.itemcount; $MBXstat.storageLimitStatus}} | Export-Csv C:\output.csv
Get-Mailbox -Database "Mailbox Database 2048287781" | sort-object | Select-Object name,alias,servername,ProhibitSendQuota,IssueWarningQuota,MaxReceiveSize,MaxSendSize,DisplayName,Database,PrimarySmtpAddress,ProhibitSendReceiveQuota,@{n="Size(KB)";e = {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.totalItemsize}},@{n="Items"; e = {$MBXstat = Get-MailboxStatistics $_.name ; $MBXstat.itemcount; $MBXstat.storageLimitStatus}} | Export-Csv C:\output.csv
For Example:
Get-Mailbox -Database "DefaultMailboxDB" | sort-object | Select-Object name,alias,servername,ProhibitSendQuota,IssueWarningQuota,MaxReceiveSize,MaxSendSize,DisplayName,Database,PrimarySmtpAddress,ProhibitSendReceiveQuota,@{n="Size(KB)";e = {$MBXstat = Get-MailboxStatistics $_.name; $MBXstat.totalItemsize}},@{n="Items"; e = {$MBXstat = Get-MailboxStatistics $_.name ; $MBXstat.itemcount; $MBXstat.storageLimitStatus}} | Export-Csv C:\DefaultDBMailbox.csv
Report mailboxes size in the entire Exchange organization:
Get-Mailbox | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount
Get-Mailbox | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount | Export-CSV C:\mailboxessize.csv
Report mailboxes size in a specific Exchange server:
Get-Mailbox -server servername | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount
Get-Mailbox -server servername | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount | Export-CSV C:\mailboxessize.csv
Report mailboxes size in a specific Exchange server database:
Get-Mailbox -server -database "Mailbox Database 0154525136" | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount
Get-Mailbox -server -database "Mailbox Database 0154525136" | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount | Export-CSV C:\mailboxessize.csv
Note: You can obtain the database name by using the command: Get-MailboxDatabase
Report specific mailbox size:
Get-Mailbox myaliasname | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount
Get-Mailbox myaliasname | Get-MailboxStatistics | Sort totalitemsize -desc | ft displayname, totalitemsize, itemcount | Export-CSV C:\mailboxessize.csv
