How to get office 365 users email internal,external and total sent count report?

Question

How to get office 365 users email internal,external and total sent count report?

Jemin Prajapati 16

Hello Team,

Anyone, please help me with how we get users' internal domain, external domain and internal & external domain sent item count reports in office 365?

Thank you.

Adeeb Ali 1 Reputation point

2022-12-27T23:04:14.737+00:00

Did you mean.
Get count of all emails sent to internal and external recipients for a particular User?
Jemin Prajapati 16 Reputation points

2022-12-28T15:51:29.94+00:00

Yes.we lookiing same
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

1 answer

Your answer

Adeeb Ali 1 Reputation point

2022-12-27T23:04:14.737+00:00

Did you mean.
Get count of all emails sent to internal and external recipients for a particular User?
Jemin Prajapati 16 Reputation points

2022-12-28T15:51:29.94+00:00

Yes.we lookiing same
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

Yuki Sun-MSFT 41,376 Moderator

Hi @Jemin Prajapati ,

How to get office 365 users email internal,external and total sent count report?

Currently, if you are the global admin of your tenant, you can get the email activity report which includes the total sent count of users via Microsoft 365 Admin Center > Reports > Usage > Exchange > Email Activity. See Microsoft 365 Reports in the admin center - Email activity.

However, when it comes to internal and external, I am afraid there's no such a feature available at present. Given this, 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 the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Jemin Prajapati 16 Reputation points

2022-12-29T05:48:34.223+00:00

Thank you for the sharing information.

Is ti possible for we can get the report exchange online Powershell?

Yuki Sun-MSFT 41,376 Moderator

Hi @Jemin Prajapati ,

Is ti possible for we can get the report exchange online Powershell?

Assuming that you only need to get the email count of a particular user, hopefully you can find the Exchange Online PowerShell script below helpful:
(Let's say you need to retrieve the data of the past 10 days)

1.Internal domain sent item count:

$InternalMails=Get-MessageTrace -SenderAddress ******@yourdomain.com -StartDate (Get-Date).AddDays(-10) -EndDate (Get-Date) | where {$_.recipientaddress -like "*yourdomain.com"}  
$InternalMails.Count

2.External domain sent item count:

$ExternalMails=Get-MessageTrace -SenderAddress ******@yourdomain.com -StartDate (Get-Date).AddDays(-10) -EndDate (Get-Date) | where {$_.recipientaddress -notlike "*yourdomain.com"}  
$ExternalMails.Count

3.Total sent item count

$TotalMails=Get-MessageTrace -SenderAddress ******@yourdomain.com -StartDate (Get-Date).AddDays(-10) -EndDate (Get-Date)  
$TotalMails.Count

Yuki Sun-MSFT 41,376 Reputation points Moderator

2023-01-02T07:48:13.457+00:00

Hi @Jemin Prajapati ,

Just wondering if you have had a chance to check the script above. Feel free to post back if there's any further questions or concerns.
Jemin Prajapati 16 Reputation points

2023-01-16T08:09:45.8266667+00:00

Thank for sharing the information with us,

Get-MessageTrace -SenderAddress ******@contoso.com -StartDate 01/08/2023 -EndDate 01/10/2023 | Group-Object -Property sender

Count Name Group

1000 {Microsoft.Exchange.Management.FfoReporting.MessageTrace, Microsoft.Exchange.Management.FfoReporting.MessageTrace, Microsoft.Exchange.Management.FfoReporting.MessageTrace, Microsoft.Exchange.Management...

We get the count but we did not receive the sender's name. the sender is empty. could you please help how we can get the sender's name on the output?

Share via

How to get office 365 users email internal,external and total sent count report?

1 answer

Your answer