It’s a well known fact that reporting is the sexiest topic in IT. To that end, I thought I’d post a quick one liner about email flow reporting in your organisation. This came about following a request from one of my favourite customers, who needed a way to report on how much email was being sent and received out of hours.
Get-MailTrafficReport -StartDate 01/14/2018 -EndDate 01/22/2018 -AggregateBy Hour -EventType GoodMail | select Date,Direction,MessageCount | Export-csv C:\users\emily\Desktop\mailflowreport.csv
This PS command is run in Exchange Online Powershell and will result in a CSV which shows an hourly breakdown of email sent / received in a given time period. It’s possible to add specific times to the dates (eg “01/14/2018 05:00”). I used the -EventType GoodMail variable to only report on Accepted mail in this example. You can also filter on -Direction (Inbound or Outbound). Below is a snapshot of the results:
Date Event Type Direction Action Message Count ------ ---- ---------- --------- ------ ------------- 15/01/2018 14:00:00 GoodMail Inbound 430 15/01/2018 15:00:00 GoodMail Inbound 230 15/01/2018 16:00:00 GoodMail Inbound 187 15/01/2018 18:00:00 GoodMail Inbound 57 15/01/2018 18:00:00 GoodMail Outbound 124 15/01/2018 19:00:00 GoodMail Inbound 34 15/01/2018 19:00:00 GoodMail Outbound 87
The TechNet article on the Get-MailTrafficReport cmdlet is here
This is a very versatile reporting function which can yield interesting data. This data can then be fed into PowerBI or a.n.other reporting tool to add some visual showmanship to the results!