Forum Discussion
Any way to generate a report on a specific mailbox with message counts?
Howdy,
We are in Office 365 and our accounting department is looking for a way to get reports on the "Accounting" shared mailbox. They would like information such as:
- How many messages came into the Accounting inbox in the last month
- How many went out
- How many that went out were stand alone messages vs replies to existing conversations
- and probably more things they'll think of
Is there any way to get this data in a report form and possibly to schedule it so that on the 1st of every month it would generate the information and email it to someone?
Thanks.
2 Replies
The first 2 of your requirements are a general one, and you shall check for numerous pre-built script available on the internet already.
Your 3rd requirement is not a very general requirement and I believe you have more specific requirement like this. So I strongly recommend you to explore 'https://docs.microsoft.com/en-us/powershell/module/exchange/mail-flow/get-messagetrace?view=exchange-ps' and start crafting your code.
Also, please check the 'https://demo.admindroid.com/#/exchange/reports/10208/1/20' offered by https://admindroid.com which covers your basic requirements and scheduling & emailing part.There's no report that will show you such data, the closes you can get is the Email activity report, but that's only for user mailboxes and it doesnt include shared ones. So, you will have to craft your own by crawling the message trace logs, or use a third-party product that automates this.
This script is a good start: https://gallery.technet.microsoft.com/scriptcenter/Office-365-Mail-Traffic-afa37da1#content
