question

PKarma avatar image
0 Votes"
PKarma asked KaelYao-MSFT commented

Distribution List Email Volume Report

There's reports in the O365 Admin Center and PowerBI O365 Data Dashboards summarizing individual user mail flow data

Is there any way to get a report on how much email a distribution list receives? We have many in use in our organization and are trying to understand the volume and trends of how often they're used.

office-exchange-online-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KaelYao-MSFT avatar image
0 Votes"
KaelYao-MSFT answered KaelYao-MSFT commented

Hi @PKarma

I suppose you may use the message trace feature in the Exchange admin center to get the amount of messages sent to specific distribution lists.
It can trace the messages up to the past 90 days.
134856-07.png

You may also use the Get-MessageTrace command in Exchange Online Powershell.


If the response 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.


07.png (46.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KaelYao-MSFT

While we can manually pull these from message trace, it would be a lot of manual work. The ask from our business is to track a large list of important distribution list to measure mail volume changes overtime.

I'm looking for a way to scope these in reports I can regularly pull from (like the powerbi 365 dashboard) - or how the reports are built into the main o365 portal. From these tools I can get mail analytics from individual users, but not distribution lists.

0 Votes 0 ·

Hi,

I am afraid there isn't built-in feature in Microsoft admin 365 to generate analytics for distribution lists.
And as a workaround, I suppose you may use the message trace to analyse the message counts sent to all distribution lists.

While we can manually pull these from message trace, it would be a lot of manual work.

Otherwise I wonder if using a Powershell script instead to bulk pull the results would work for you.
0 Votes 0 ·