Generate a CSV report detailing the total size of and number of items in each Exchange user's Deleted Items folder.

exchange-report-deleted-items.ps1

cls
echo "Generating report for deleted items folders..."
echo "Please wait..."

$data = @()
foreach($mbx in Get-MailboxDatabase | Get-Mailbox) { 
	$dispname = $mbx.displayName

	$data += Get-MailboxFolderStatistics $mbx.identity | where{$_.FolderType -eq "DeletedItems"} | Select-Object @{n="Username";e={$mbx.displayName}}, @{n="TotalSizeIncSubfolders(MB)";e={$_.FolderAndSubFolderSize.ToMb()}}, ItemsInFolderAndSubFolders
}

echo "Exporting report to C:\Temp\exchange-report-deleted-items.csv..."

$data | Sort-Object "TotalSizeIncSubfolders(MB)" –Descending | Export-Csv C:\Temp\exchange-report-deleted-items.csv

echo "All done!"