Scheduling Mail Reports in Office 365

Obtaining reports in the past was a manual task which had to be performed every time you wanted to pull data. Many of you (most of you?) have asked us to allow for automated reporting in Office 365. Did you catch how I used the words, “in the past,” in the first sentence?

Well, I’m happy to say that automated reporting in Office 365 has arrived and is now available in your tenant. Reports can be scheduled for delivery either on a weekly or monthly basis.

How it works

Currently the following types of reports can be scheduled.

  • Mail traffic summary (sent and received mail)
  • Spam detections summary
  • Rule matches
  • Data Loss Prevention policy matches

To create a schedule for a report, first head over to the Reports section in the Office 365 Portal. Open up your favourite mail report and then select “Schedule Report.”

From here the report can be scoped (ex. Show inbound mail only), and can be scheduled to run either weekly or monthly.

When the report runs, you’ll receive a message that looks something like this.

If you would like to receive a report daily, you can setup 7 different schedules for the same report, each starting on a different day of the week. To view current schedules, open up your report in the portal and click the link “View Scheduled Reports,” which is right under the link “Schedule this Report.”

Spam Detections Report

I would like to call out one report that I think is particularly valuable. When you schedule a Spam Detections report, you will receive an email with the summary of the results, but it will also include a CSV file which provides a breakdown of the type of spam that EOP detected.

This type of data can be very powerful for trending the types of attacks that your organization has received.

Domain Level traffic reporting

Another new addition to reporting is the ability to breakdown traffic by domain. These reports can currently only be generated through PowerShell using the “Domain” parameter with the following cmdlets.

  • Get-MailTrafficReport
  • Get-MailTrafficPolicyReport

Have a great weekend, cheers!


Schedule mail protection reports in Office 365 to be automatically sent to your inbox
7 new Exchange Online Protection enhancements