Mail sent & received during a year

Niranjan T Pattana Shetty 266 Reputation points

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?

Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
6,082 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Niranjan T Pattana Shetty 266 Reputation points

    Hi All,
    Is there anything needed from my end?

    No comments

  2. Joyce Shen - MSFT 16,331 Reputation points Microsoft Employee

    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.

    No comments

  3. Niranjan T Pattana Shetty 266 Reputation points

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