Request for Email Activity Report with Internal/External Breakdown

Aran Billen 761 Reputation points
2024-06-19T12:56:03.7066667+00:00

Hi everyone,

Is it possible to generate a report that shows the number of emails sent and received by each user, with a breakdown of internal and external emails?

I understand that we can find some basic metrics in the admin center under Reports > Usage > Exchange > Email activity. However, this does not separate the count of internal and external emails.

Does anyone have any suggestions or know of a way to achieve this?

Thank you!

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,281 questions
Microsoft Exchange Online
Microsoft Exchange
Microsoft Exchange
Microsoft messaging and collaboration software.
453 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,290 questions
0 comments No comments
{count} votes

Accepted answer
  1. Noah Ma-MSFT 2,340 Reputation points Microsoft Vendor
    2024-06-20T06:53:01.3066667+00:00

    Hi @Aran Billen ,

    Thank you for posting to Microsoft Community.

    As you mentioned, you could get the email activity report which includes the total sent count of users via Microsoft 365 Admin Center.

    However, I am afraid there's no such a feature to select internal and external emails report separately at present.

    You could run the following command to get the number of external/internal emails sent in the last 30 days by specific users:

    Get-MessageTrace -RecipientAddress <user_email_address> -StartDate (Get-Date).AddDays(-30) -EndDate (Get-Date) | Where-Object {$_.SourceContext -notlike “*onmicrosoft.com 8”} | Select-Object RecipientAddress, SenderAddress | Group-Object RecipientAddress | Select-Object Name, Count
    

    Then please kindly replace the “notlike” in the command to “like” to check the internal emails.

    You can repeat the command for each user and combine the results to get a report of the number of external/internal emails sent by all the users you are interested in.

    Also, I've just tried submitting a suggestion via the dedicated feedback portal for Exchange Online. I'll leave the link below so that you or other community members can also add vote or comment there. Let's hope this kind of report can be added in the future. https://feedbackportal.microsoft.com/feedback/idea/f6386999-5e86-ed11-a81b-6045bdaf6a9e

    If my answer is any helpful to you, please mark it as the answer so that other users can refer to it. Thank you for your support and understanding.


0 additional answers

Sort by: Most helpful