I need to make a report with a list of the largest messages on an Exchange 2010 server. I looked through the commands that I could use, and Get-MailboxStatistics isn't granular enough - I need to find individual messages >25MB and print their size, user account, and subject. This is for a migration to Google Apps, so I can figure out who (if anyone) has these huge emails Apps won't accept.
From what I can see, you can use Multi-Mailbox Search in conjunction with Advanced Query Syntax to perform a search of specific characteristics. I don't have much else to give you but those pointers.
Ideally I'd want to be able to do something with Powershell. The only thing I could come up with is the following:
This would give you a log entry for of all the messages that meet your criteria in whatever mailbox you specify (in this case
SomeMailbox
) in theExport
folder. The-LogOnly
parameter makes sure it doesn't actually copy the messages in question to the specified mailbox/folder.