A cloud-based service included in Microsoft 365, delivering scalable messaging and collaboration features with simplified management and automatic updates.
Hi @Megha Devrani,
For a per-user report covering the last 24 hours, the most suitable option is Message Trace in Exchange Online PowerShell. Microsoft provides the cmdlet syntax and examples in the following documentation: Get-MessageTraceV2.
You can retrieve message trace data for the last 24 hours, group the results by sender, and export them to a CSV file. When calculating the number of messages, use unique MessageTraceId values to help avoid counting the same message multiple times when it was sent to multiple recipients.
Please note that Get-MessageTraceV2 returns a maximum of 5,000 results per query. For tenants with higher mail volume, divide the 24-hour period into smaller time ranges to ensure the report is complete.
Alternatively, the admin can go to Exchange admin center > Mail flow > Message trace > Start a trace, select the last 24 hours, leave the sender field blank to search the whole tenant, and export the results. You can also refer: Message trace in the Exchange admin center
I hope this answer provides helpful documentation for generating the report and tracking email-sending activity across your tenant. If you need any further clarification, please feel free to comment below.
Thank you so much for taking the time.
If the answer is helpful, please kindly click "Yes" button below. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.