🎉 Our Microsoft 365 Reporting & Management Tool is available in Marketplace 🚀
Exchange Online

How to Get the User Email Statistics Report in Microsoft 365

How can Office 365 mail traffic reports help you track emails sent and received by each user? You can easily detect anomalies, enhance security, and ensure compliance with Microsoft 365 email traffic reports. Gain valuable insights on email volumes per user, number of emails sent and received, and email usage in Microsoft 365. This actionable data can help you improve productivity and workload metrics.

Microsoft 365 tools

Using Microsoft 365 Admin Center

Microsoft 365 Permission Required
Global Admin or Exchange Online Admin.
  • Navigate to the Reports section, then access Usage Reports»Exchange»Email Activity.
  • Scroll down to get the Office 365 users and their actvities in emails.
Using Microsoft 365 Admin Center

Using Exchange Admin Center

Microsoft 365 Permission Required
Global Admin or Exchange Online Admin.
  • Navigate to the Message trace residing under Mail flow with the required admin permissions.
  • Start a new trace with the time range of your requirement, and you can also download message trace report to a CSV format in Exchange Online.
Using Exchange Admin Center

Using PowerShell Script

Microsoft 365 Permission Required
Global Admin or Exchange Online Admin.
  • We have prepared a PowerShell script that efficiently retrieves the number of emails sent and received since there is no way to obtain a detailed mail traffic report with a single cmdlet.
  • Download and run the following script in the Administrator PowerShell. You can retrieve the past 90 days data.
Using PowerShell Script
MailTrafficReport.ps1
  • By default, the script retrieves the mail received count. To count the number of emails sent use the –MailSent parameter while running the script.

Simplifying the task of monitoring and managing emails!

AdminDroid email monitoring tool stands as a comprehensive solution for Microsoft 365 admins! Effortlessly manage user email counts with top email statistics and gain valuable insights without the need for complex PowerShell scripts.

Safeguard Information and Enhance Compliance

Gain insights into all incoming and outgoing emails in your Microsoft 365 organization.

Secure Your Email Environment

Discover the extent of spam and malware detection in your organization with Exchange Online Protection (EOP) reports.

Streamline Alert Generation for External Domains

Set up alert policies to detect when mail is sent to or received from unauthorized external domains.

Office 365 Email Metrics Insights

Discover daily email activity with AdminDroid, revealing incoming and outgoing mail traffic for each mail-enabled user in your organization.

Streamline the Reporting Process with Automated Generation

Schedule email traffic analysis reports delivered directly to your inbox, ensuring constant updates on your Microsoft environment.

Customizable Report Export

Export email activity reports with advanced filtering, column merging, and sorting options. Customize reports to admins' preferences, providing accurate insights for streamlined sharing.

Overall, AdminDroid email monitoring tool enables seamless management and tracking of emails sent and received in your Office 365 environment. With this comprehensive solution, Microsoft 365 admins can effortlessly track and analyze email activity, gaining valuable insights into user communication patterns in your Microsoft 365 environment.

Important Tips

Prioritize the identification and filtering of spam mail to safeguard against threats and optimize communication efficiency.

Monitor mail delivery failures to maintain reliable communication in your Exchange Online environment.

Educate users on identifying and Microsoft 365 reporting suspicions or phishing emails to mitigate security risks.

Common Errors and Resolution Steps

The following are possible errors and troubleshooting hints while dealing with emails in Microsoft 365 Exchange Online.

Error Get-MailboxStatistics: The specified mailbox "X" isn't unique.

This error occurs when PowerShell attempts to utilize a non-unique value for the -Identity parameter.

Fix To resolve this error, use UPN or User ID for Identity value

Error Mail traffic can be retrieved only for the past 90 days.

This error indicates that the Exchange Online mail traffic cmdlet can only retrieve data for the past 90 days.

Fix Ensure that the given start date and end date do not exceed 90 days.

Error Your Mailbox is Full, you may not be able to send or receive items.

This error occurs when the user Exchange Online mailbox storage is full.

Fix To resolve this error, you can increase the storage quota for prohibit send receive parameters. And frequently monitor mailbox usage to avoid Exchange Online mailbox quota exceeding.

Error ./MailTrafficReport.ps1 cannot be loaded because running scripts is disabled on this system.

This error occurs when trying to run the script. The execution policy is set to “strict” by default to prevent scripts from running.

Fix To resolve this error, you can set the execution policy to run the script.
// Run any one of the cmdlet below to set the execution policy.

Set-ExecutionPolicy -ExecutionPolicy Unrestricted
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned

Error Not Started (Message trace not started for too long)

The error occurs when we try to pull email traffic analytics from exchange online for an extended report.

Fix You can use the summary report option. You can also set filters to mailboxes and date period and receive the report in the mail.

Kickstart Your Journey With
AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities

Download Now
User Help Manuals Compliance Docs Customer Stories