There may be times when it would be beneficial to determine where the majority of the mail from your enterprise is coming from and who is sending it. Is there an easy way to determine who are the top 20 email senders in the archive?
The following SQL query will provide you with the top 20 email addresses of users that sent the largest of amount of emails in your archive:
SELECT EA.EmailAddress, MR.FromCount
(SELECT TOP 20 COUNT(*) AS FromCount, EmailAddressID
FROM dbo.MessageRecipient AS MR
WHERE RecipientType = 'From'
GROUP BY EmailAddressID
ORDER BY FromCount DESC) AS MR
JOIN dbo.EmailAddress AS EA ON EA.EmailAddressID = MR.EmailAddressID