Find Oldest Email in a Exchange Mailbox

There are requirements when you need to find oldest email in a mailbox so that you can take necessary decisions. I could remember these one scenario when this happens.

• You have to deploy Exchange Retetnion POlicies on a Mailbox and want to know what type of emails will be deleted.

There is a simple one liner to extract stats against mailbox or set of mailboxes.

• Launch On-Prem Exchange or Exchange Online Powershell.
•  
• Run this command against one mailbox, It will dump data to a CSV on your desktop.

Run this command against one mailbox, It will dump data to a CSV on your desktop.

Get-MailboxFolderStatistics -ID <mailboxemailaddress> -IncludeOldestAndNewestItems | select Identity, Name, FolderPath, ItemsInFolder, FolderSize, OldestItemReceivedDate | Export-Csv $home\desktop\MB.csv -NoTypeInformation

Run against all mailboxes, but that will take so much time to export.

Get-Mailbox -resultsize unlimited| % {Get-MailboxFolderStatistics -id $_ -IncludeOldestAndNewestItems} | select Identity, Name, FolderPath, ItemsInFolder, FolderSize, OldestItemReceivedDate | Export-Csv $home\desktop\AllMB.csv -NoTypeInformation

Run against set of mailboxes, Copy list of email address in a .txt file and run below command.

GC $home\desktop\input.txt | % {Get-MailboxFolderStatistics -id $_ -IncludeOldestAndNewestItems} | select Identity, Name, FolderPath, ItemsInFolder, FolderSize, OldestItemReceivedDate | Export-Csv $home\desktop\FewMB.csv -NoTypeInformation

Thank you reading !