Mail sent & received during a year

Niranjan T Pattana Shetty 286 Reputation points
2020-11-19T12:08:37.307+00:00

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.
7,260 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Niranjan T Pattana Shetty 286 Reputation points
    2020-11-20T04:38:00.12+00:00

    Hi All,
    Is there anything needed from my end?

    0 comments No comments

  2. Joyce Shen - MSFT 16,631 Reputation points
    2020-11-20T06:22:47.397+00:00

    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.

    0 comments No comments

  3. Niranjan T Pattana Shetty 286 Reputation points
    2020-11-20T18:16:23.537+00:00

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