Home

Any way to generate a report on a specific mailbox with message counts?

%3CLINGO-SUB%20id%3D%22lingo-sub-643815%22%20slang%3D%22en-US%22%3EAny%20way%20to%20generate%20a%20report%20on%20a%20specific%20mailbox%20with%20message%20counts%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-643815%22%20slang%3D%22en-US%22%3E%3CP%3EHowdy%2C%3C%2FP%3E%3CP%3EWe%20are%20in%20Office%20365%20and%20our%20accounting%20department%20is%20looking%20for%20a%20way%20to%20get%20reports%20on%20the%20%22Accounting%22%20shared%20mailbox.%26nbsp%3B%20They%20would%20like%20information%20such%20as%3A%3C%2FP%3E%3CUL%3E%3CLI%3EHow%20many%20messages%20came%20into%20the%20Accounting%20inbox%20in%20the%20last%20month%3C%2FLI%3E%3CLI%3EHow%20many%20went%20out%3C%2FLI%3E%3CLI%3EHow%20many%20that%20went%20out%20were%20stand%20alone%20messages%20vs%20replies%20to%20existing%20conversations%3C%2FLI%3E%3CLI%3Eand%20probably%20more%20things%20they'll%20think%20of%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIs%20there%20any%20way%20to%20get%20this%20data%20in%20a%20report%20form%20and%20possibly%20to%20schedule%20it%20so%20that%20on%20the%201st%20of%20every%20month%20it%20would%20generate%20the%20information%20and%20email%20it%20to%20someone%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-643815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644969%22%20slang%3D%22en-US%22%3ERe%3A%20Any%20way%20to%20generate%20a%20report%20on%20a%20specific%20mailbox%20with%20message%20counts%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644969%22%20slang%3D%22en-US%22%3E%3CP%3EThere's%20no%20report%20that%20will%20show%20you%20such%20data%2C%20the%20closes%20you%20can%20get%20is%20the%20Email%20activity%20report%2C%20but%20that's%20only%20for%20user%20mailboxes%20and%20it%20doesnt%20include%20shared%20ones.%20So%2C%20you%20will%20have%20to%20craft%20your%20own%20by%20crawling%20the%20message%20trace%20logs%2C%20or%20use%20a%20third-party%20product%20that%20automates%20this.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20script%20is%20a%20good%20start%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2Fscriptcenter%2FOffice-365-Mail-Traffic-afa37da1%23content%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgallery.technet.microsoft.com%2Fscriptcenter%2FOffice-365-Mail-Traffic-afa37da1%23content%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-650064%22%20slang%3D%22en-US%22%3ERe%3A%20Any%20way%20to%20generate%20a%20report%20on%20a%20specific%20mailbox%20with%20message%20counts%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650064%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F47110%22%20target%3D%22_blank%22%3E%40Mike%20Boehm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%202%20of%20your%20requirements%20are%20a%20general%20one%2C%20and%20you%20shall%20check%20for%20numerous%20pre-built%20script%20available%20on%20the%20internet%20already.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%203rd%20requirement%20is%20not%20a%20very%20general%20requirement%20and%20I%20believe%20you%20have%20more%20specific%20requirement%20like%20this.%20So%20I%20strongly%20recommend%20you%20to%20explore%20'%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fexchange%2Fmail-flow%2Fget-messagetrace%3Fview%3Dexchange-ps%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EGet-MessageTrace%3C%2FA%3E'%20and%20start%20crafting%20your%20code.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%2C%20please%20check%20the%20'%3CA%20href%3D%22https%3A%2F%2Fdemo.admindroid.com%2F%23%2Fexchange%2Freports%2F10208%2F1%2F20%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EDaill%20User%20Email%20Traffic%20Report%3C%2FA%3E'%20offered%20by%20%3CA%20title%3D%22AdminDroid%20Office%20365%20Reporting%20tool%22%20href%3D%22https%3A%2F%2Fadmindroid.com%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAdminDroid%3C%2FA%3E%20which%20covers%20your%20basic%20requirements%20and%20scheduling%20%26amp%3B%20emailing%20part.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Mike Boehm
Regular Contributor

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

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

@Mike Boehm 

 

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 'Get-MessageTrace' and start crafting your code. 

Also, please check the 'Daill User Email Traffic Report' offered by AdminDroid which covers your basic requirements and scheduling & emailing part.

Related Conversations