Scenario: Determine the true size of a mailbox by adding together the TotalItemSize and TotalDeletedItemSize values together via a script and put the values into a table. These values are properties of the Get-MailboxStatistics commandlet.
Note: The TotalDeletedItemSize is not included in the TotalItemSize value for a mailbox. Test it by deleting all of your mailbox content and comparing the values before and after. Then perform a mailbox move and Exchange will show the total size of the mailbox which is a combination of the two.
Script:
#query for your mailboxes $stat = get-mailboxdatabase DB* | Get-mailboxstatistics | Select DisplayName,TotalDeletedItemSize, TotalItemSize,ItemCount #Define array variable $final = @() #Loop $stat | %{ $TIS = $_.TotalItemSize.Value.ToMB() | Measure-object -sum $TDIS = $_.TotalDeletedItemSize.Value.ToMB() | Measure-object -sum $Total = $TIS.sum + $TDIS.sum #Build the Array $ServerObj = New-Object PSObject $ServerObj | Add-Member NoteProperty -Name "DisplayName" -Value $_.DisplayName $ServerObj | Add-Member NoteProperty -Name "MbxSize(InMB)" -Value $total $Final += $ServerObj } $Final