🎉 Our Office 365 Reporting Tool is now available in Azure Marketplace 🚀
This website uses cookies to improve your experience. We'll assume you're ok with this. Know more.
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.

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.

Explore a full range of reporting options

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.

Frequently Asked Questions

Find out total emails sent and received per mailbox each day in Microsoft 365

Is there a limit to send emails in Outlook?

Is there a limit to send emails in Outlook? +

Yes, to enhance protection against spammers, Microsoft Outlook has implemented measures to limit the volume of email messages you can send in a day, as well as the number of recipients allowed per message.

These restrictions are in place to ensure a secure email environment and prevent misuse of the platform, safeguarding both senders and recipients from potential spam-related threats.

The email limits for Microsoft 365 subscribers are as follows:

  • Daily recipients: 5,000
  • Maximum recipients per message: 500
  • Daily non-relationship recipients: 1,000

To increase sending limits,

There is no direct way to increase email sending limits, Microsoft ensures the validation of an account to increase sending limits.

  • Keep your account information up to date, including your phone number and alternate email address.
  • Update your account's profile information, such as Profile Name, Photo, Date of Birth, and Gender.
  • Create a strong password that includes a combination of uppercase/lowercase letters, numbers, and special characters.
  • Add frequently contacted people to your Contacts in Outlook.com.
  • Communicate frequently with your Contacts.

How to get to the email activity report?

How to get to the email activity report? +

The email activity report in Microsoft 365 provides insights and analytics on email usage and activity within an organization. To get an email activity report:

  • Sign-in to Microsoft 365 admin center.
  • Navigate to Exchange resided under Reports»Usage.
  • Under the email activity section, use the column ‘send actions’ and ‘receive actions’ to get the sent and received mail count.

The Email activity report can be viewed for trends over the last 7 days, 30 days, 90 days, or 180 days.

However, if you select a particular day in the report, the table will show data for up to 28 days from the current date (not the date the report was generated).

AdminDroid enables you to generate reports on your users' email stats, providing insights on email activity across internal and external domains with the exact number of sent and received emails. Additionally, you can obtain reports based on emails per day for a comprehensive analysis of email traffic trends.

  • AdminDroid stores the accumulated data indefinitely, without any retention period.
  • This allows users to access the data at any time, ensuring flexibility and convenience.
email-activity-report

How to count emails for a specific mailbox or domain?

How to count emails for a specific mailbox or domain? +

To get the number of emails sent from a mailbox or domain,

  • Login to the Exchange Online admin center.
  • Navigate to Message trace resided under Mail flow.
  • Mail flow reports offer the option of default queries or creating a message trace for individual mailboxes or all mailboxes.
message-trace-1
message-trace-2

Limitations in Exchange Admin Center

  • The default value is 2 days, but you can specify date/time ranges of up to 90 days.
  • It may take several hours before your report is ready for download.
  • The availability time depends on the workload and the number of report requests from other admins. If there are many requests in the queue, you may experience a delay before your request starts to be processed.
  • The maximum size for a downloadable report is 800 MB. If a downloadable report exceeds 800 MB, you can't open the report in Excel or Notepad.

Use AdminDroid Microsoft 365 email monitoring tool to,

  • Have ready-to-download reports available anytime.
  • Handle simultaneous report downloads and export reports to the major formats: PDF, CSV, XLS, XLSX, HTML and RAW.
  • Download with no restriction on file sizes.
  • Set filters for domains using the Simple filter option which would be useful for segregating reports based on domains.
simple-filter

How to monitor the number of emails sent and received?

How to monitor the number of emails sent and received? +

Regular monitoring of Exchange Online mailbox usage is essential to prevent mailboxes exceeding mailbox quota, as it can lead to email disruptions and communication issues.

By using the mentioned native solutions, efficiently you can track the number of emails sent and received within a Microsoft 365 environment through the Exchange Online admin center's message trace or PowerShell script.

You may also use the provided PowerShell cmdlet below, offering a convenient method to generate a list of all users alongside their respective counts of sent and received emails.

Connect-ExchangeOnline

$endDate = Get-Date
$startDate = $endDate.AddDays(-10)
$users = Get-EXOMailbox -ResultSize Unlimited
foreach ($user in $users) {
$emailAddress = $user.PrimarySmtpAddress $sentEmailsCount = Get-MessageTrace -StartDate $startDate -EndDate $endDate -SenderAddress $emailAddress | Measure-Object | Select-Object -ExpandProperty Count $receivedEmailsCount = Get-MessageTrace -StartDate $startDate -EndDate $endDate -RecipientAddress $emailAddress | Measure-Object | Select-Object -ExpandProperty Count
Write-Output "User: $emailAddress"
Write-Output "Sent Emails Count: $sentEmailsCount"
Write-Output "Received Emails Count: $receivedEmailsCount"
Write-Output ""
}

With AdminDroid, you can effortlessly receive a daily report on the number of emails sent and received by each user.

  • We recommend you use the ‘Schedule this report now’ option to send the report periodically to your inbox.
  • You can also check whether the schedule has been created by navigating to the Schedule Reports page in your AdminDroid portal.
  • Additionally, you can use the Intelligent Filter option on the Schedule Reports page to view only the previous day's activities, allowing you to focus solely on the email metrics relevant to that specific time frame.
monitor-emails-send-received

Is it possible to get a message count for an Exchange Online shared mailbox?

Is it possible to get a message count for an Exchange Online shared mailbox? +

Yes, as an Exchange admin, you can directly retrieve the message count from a shared mailbox using PowerShell commands.

Get-MailboxFolderStatistics -Identity <SharedMailboxName> -FolderScope Inbox | Select-Object FolderPath, ItemsInFolder

If you want to check other folders within the shared mailbox, you can change the -FolderScope parameter to the desired folder.

One of the disadvantages of relying solely on native Microsoft 365 solutions is that they do not provide a direct method to retrieve the number of emails sent by a particular user using a shared mailbox.

With AdminDroid's Mailbox Analytics reporting, Microsoft 365 admins can now gain valuable insights into shared mailboxes, including the number of draft emails and their ownership.

  • Additionally, AdminDroid empowers admins to determine the email sender in a thread, enhancing email traceability and tracking communication. Detailed reporting on mail response time and drafted durations further aids in understanding email handling patterns.
  • Moreover, the reporting provides essential mailbox folder statistics, encompassing the count, size, and permissions of each folder, offering comprehensive visibility into mailbox organization.
  • With these advanced analytics features, AdminDroid enables admins to optimize email traffic management in Exchange and enhance collaborative efforts to improve overall efficiency within the organization.

How to manage office 365 mail traffic statistics by user?

How to manage office 365 mail traffic statistics by user? +

Tracking email activity can provide valuable insights into productivity and collaboration. By analyzing the total number of emails sent in an hour, day or week, Microsoft 365 admins can gain insights into communication channel utilization, identify improvement areas, and assess workload distribution.

However, Microsoft 365 native solutions lack in-depth insights into email activity. They do not provide peak period analysis, which identifies peak email communication times, or slack period analysis, which pinpoints periods of reduced activity.

Without this valuable information, admins may find it challenging to assess user productivity during critical periods, identify communication trends, and optimize workflow accordingly.

Unlock productivity's secrets with AdminDroid: Delve into email activity, fine-tune communication, and boost efficiency.

AdminDroid provides a wide range of comprehensive Microsoft 365 reports, such as monitoring email activity, and differentiating email count sent and received between external and internal domains.

  • With its powerful analytics capabilities, AdminDroid enables admins to track and analyze the number of emails sent and received based on hourly and daily trends, unveiling the most active periods of communication.
  • Moreover, its specialized features allow users to identify slack periods, when email activity is reduced, and pinpoint peak hours, when communication is at its highest.
  • These detailed reports empower admins to understand the dynamics of email activity, optimize communication strategies, and enhance overall productivity.
m365-email-monitoring

With AdminDroid's powerful email analytics and auditing, monitoring becomes effortless.

+

Kickstart Your Journey With
AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities

Download Now
User Help Manuals Compliance Docs
x
Delivering Reports on Time
Want a desired Microsoft 365 reports every Monday morning? Ensure automated report distribution and timely delivery with AdminDroid's Scheduling to your email anytime you need.
Delivering Reports on Time
Schedule tailored reports to execute automatically at the time you set and deliver straight to the emails you choose. In addition, you can customize report columns and add inteligent filtering to the activities just from the previous day to suit your Microsoft 365 report requirements.
Set It, Schedule It, See Results- Your Reports, Your Way, On Your Time!
Time Saving
Automation
Customization
Intelligent Filtering
Give Just the Right Access to the Right People
Grant fine-tuned access to any Microsoft 365 user with AdminDroid’s Granular Delegation and meet your organization’s security and compliance requirements.
Give Just the Right Access to the Right People
Create custom roles loaded with just the right permissions and give access to admins or normal users within AdminDroid. The result? A streamlined Microsoft 365 management experience that aligns your organization's security protocols and saves your invaluable time and effort.
Align, Define, Simplify: AdminDroid's Granular Delegation
Smart Organizational Control
Effortless M365 Management
Simplified Access
Advanced Alerts at a Glance
Receive quick notifications for malicious Microsoft 365 activities. Engage with the AdminDroid’s real-time alert policies crafted to streamline your security investigations.
Advanced Alerts at a Glance
Stay informed of critical activities like suspicious emails and high-risk logins, bulk file sharing, etc. Through creating and validating ideal alert policies, AdminDroid provides a comprehensive approach to real-time monitoring and management of potential threats within your organization.
AdminDroid Keeps You Always Vigilant, Never Vulnerable!
Proactive Protection
Real-time Monitoring
Security Intelligence
Threat Detection
Merge the Required Data to One Place
Combine multiple required columns into one comprehensive report and prioritize the information that matters most to you with AdminDroid’s Advanced Column Customization.
Merge the Required Data to One Place
This column merging capability offers a flexible way to add different columns from various reports and collate all the essential data in one place. Want to revisit the customized report? Save it as a 'View’, and your unique report is ready whenever you need it.
Merge with Ease and Save as Views!
Custom Reporting
Unique View
Desired Columns
Easy Data Interpretation
Insightful Charts and Exclusive Dashboards
Get a quick and easy overview of your tenant's activity, identify potential problems, and take action to protect your data with AdminDroid’s Charts and Dashboards.
Insightful Charts and Exclusive Dashboards
With AdminDroid charts and dashboards, visualize your Microsoft 365 tenant in ways you've never thought possible. It's not just about viewing; it's about understanding, controlling, and transforming your Microsoft 365 environment.
Explore Your Microsoft 365 Tenant in a Whole New Way!
Executive overviews
Interactive insights
Decision-making
Data Visualization
Efficient Report Exporting for Microsoft 365
Downloading your reports in the right file format shouldn’t be a hassle with AdminDroid’s Report Export. Experience seamless report exporting in various formats that cater to your needs.
Efficient Report Exporting for Microsoft 365
Navigate through diverse options and export Microsoft 365 reports flawlessly in your desired file format. Tailor your reports precisely as you need them and save them directly to your computer.
Take Control, Customize and Deliver- Your Office 365 Data, Exported in Your Way!
Easy Export
Seamless Downloading
Data Control
Manage Microsoft 365

Get AdminDroid Office 365 Reporter Now!