How to Get the User Email Statistics Report in Microsoft 365

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:

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.

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

Limitations in Exchange Admin Center

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 ""
}

• 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.

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.

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.