SOLVED
Home

Extract Monthly Report from Email Activities

%3CLINGO-SUB%20id%3D%22lingo-sub-278929%22%20slang%3D%22en-US%22%3EExtract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278929%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20extract%20a%20report%20of%20emails%20sent%20and%20received%20from%20some%20users%2C%20referring%20to%20the%20month%20of%20September%202018.%20How%20can%20I%20do%20this%3F%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-278929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279251%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279251%22%20slang%3D%22en-US%22%3EHere%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fexchange%2Freporting%2Fget-mailtrafficreport%3Fview%3Dexchange-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fexchange%2Freporting%2Fget-mailtrafficreport%3Fview%3Dexchange-ps%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279249%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279249%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20not%20possible%20with%20powershell%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279245%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279245%22%20slang%3D%22en-US%22%3EYou%20have%20go%20to%20reports%20or%20message%20trace%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279243%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279243%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20tried%20to%20run%20through%20the%20administration%20center%2C%20however%2C%20a%20daily%20report%20is%20shown%20(day%20after%20day)%20and%20I%20would%20like%20a%20consolidated%20one%20of%20the%20month%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279134%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279134%22%20slang%3D%22en-US%22%3EOk!%20The%20first%20option%20I%20sent%20is%20enough%20then%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279110%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279110%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20only%20need%20the%20count%20of%20emails%20sent%20and%20received.%20For%20example%20user1%40domain.com%20sent%20xx%20emails%20and%20received%20xx%20emails%20in%20the%20month%20of%20September%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279008%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279008%22%20slang%3D%22en-US%22%3ETrue!%20If%20thats%20What%20you%20need%2C%20there%E2%80%99s%20content%20search%20and%20Ediscovery.%20You%20can%20export%20the%20mails%20to%20a%20pst!%20Available%20from%20the%20security%20and%20compliance%20center%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279005%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279005%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20amount%20of%20details%20you%20want%20is%20also%20relevant.%20Is%20it%20just%20basically%20a%20count%2C%20or%20do%20you%20want%20to%20be%20able%20to%20extract%20all%20of%20the%20e-mails%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fquadro.tech%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EQuadrotech%3C%2FA%3E%20-%20%3CA%20href%3D%22https%3A%2F%2Fquadro.tech%2Fautopilot%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EManagement%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Fquadro.tech%2Freporting%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EReporting%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fquadro.tech%2Fmigration%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMigration%3C%2FA%3E%20for%20Office%20365%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278931%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20Monthly%20Report%20from%20Email%20Activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278931%22%20slang%3D%22en-US%22%3EYou%20can%20do%20this%20several%20ways%2C%20for%20example%20the%20usage%20reports%20in%20the%20admin%20center.%20Filter%20on%20the%20user!%20There%20is%20also%20message%20trace%20you%20can%20filter%20on%20sender%20%2F%20receiver%20%2F%20time%20period%2C%20and%20create%20a%20report!%3CBR%20%2F%3EYou%20can%20also%20programmatically%20create%20report%20and%20so%20on%20but%20it%20seems%20these%20will%20meet%20your%20needs!%20Otherwise%20explain%20your%20scenario%20further%20and%20we%E2%80%99ll%20help%20you!%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I need to extract a report of emails sent and received from some users, referring to the month of September 2018. How can I do this?

Regards

9 Replies
You can do this several ways, for example the usage reports in the admin center. Filter on the user! There is also message trace you can filter on sender / receiver / time period, and create a report!
You can also programmatically create report and so on but it seems these will meet your needs! Otherwise explain your scenario further and we’ll help you!

Adam

Adam

The amount of details you want is also relevant. Is it just basically a count, or do you want to be able to extract all of the e-mails?

 


Quadrotech - Management, Reporting and Migration for Office 365

True! If thats What you need, there’s content search and Ediscovery. You can export the mails to a pst! Available from the security and compliance center

I only need the count of emails sent and received. For example user1@domain.com sent xx emails and received xx emails in the month of September

Ok! The first option I sent is enough then :)

I tried to run through the administration center, however, a daily report is shown (day after day) and I would like a consolidated one of the month

You have go to reports or message trace

Is it not possible with powershell?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies