Mail sent & received during a year

Question

Hi All,
We have a requirement to show the numbers for below 3 aspects:

1. how many emails each mailbox sent during whole 2020?
2. each mailbox send the most emails to?
3. Who sent the most emails to every mailbox?

Mailboxes are in Exchange 2016 environment, is this possible?

Answer 1

Hi All,
Is there anything needed from my end?

Answer 2

Hi @Niranjan T Pattana Shetty

For your first question, we can use the command Get-MessageTrackingLog to meet this need. Like below

Get-mailbox -RecipientTypeDetails UserMailbox | Select Displayname, @{N="Count";E={(Get-MessageTrackingLog -ResultSize Unlimited -Start "1/1/2020 0:00AM" -End "11/20/2020 5:00PM" -sender $_.PrimarySmtpAddress |  Where {$_.EventID -eq "Deliver"}).count}}  

Please also check the MessageTrackingLogMaxAge on your server

Get-TransportServer | fl MessageTrackingLogMaxAge  

And for your 2nd and 3rd question, I'm afraid there is no original way to find the user who sent most emails to or so on. We may need to use some 3rd party tools or write some scripts to meet this need.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi Joyceshen,
Thanks for your reply, but unfortunately we can trace messages for only upto the max of 7 days.