SOLVED

O365 Activity report

%3CLINGO-SUB%20id%3D%22lingo-sub-1273532%22%20slang%3D%22en-US%22%3EO365%20Activity%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1273532%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20Admin%20can%20get%20a%20report%20with%20a%20list%20of%20Employees%20who%20are%20accessing%20the%20365%20application%20after%20business%20hours%3F%26nbsp%3B%20We%20are%20looking%20to%20create%20a%20Power%20BI%20report%20with%20information%20on%20employees%20who%20are%20sending%20emails%20after%20office%20hours%20and%20accessing%20the%20SharePoint.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20give%20some%20ideas%20to%20achieve%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1273532%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdoption%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDelve%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1273984%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20Activity%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1273984%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20only%20way%20to%20generate%20such%20report%20would%20be%20to%20crawl%20the%20Unified%20audit%20log%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fsearch-the-audit-log-in-security-and-compliance%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fsearch-the-audit-log-in-security-and-compliance%3Fview%3Do365-worldwide%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1275637%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20Activity%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275637%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58%22%20target%3D%22_blank%22%3E%40Vasil%20Michev%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20Can%20we%20access%20this%20information%20from%20the%20Audit%20log%20using%20API's%3F%26nbsp%3B%20Can%20we%20get%20this%20data%20in%20Power%20BI%3F%20Any%20advice%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20help%20on%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1275871%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20Activity%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275871%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20and%20yes...%20read%20the%20article!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1275880%22%20slang%3D%22en-US%22%3ERe%3A%20O365%20Activity%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275880%22%20slang%3D%22en-US%22%3EThank%20you%20!!%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

Is there a way Admin can get a report with a list of Employees who are accessing the 365 application after business hours?  We are looking to create a Power BI report with information on employees who are sending emails after office hours and accessing the SharePoint. 

 

Can anyone please give some ideas to achieve this? 

 

Appreciate your help

 

Thanks 

 

4 Replies
best response confirmed by kris_vin (New Contributor)
Solution

The only way to generate such report would be to crawl the Unified audit log: https://docs.microsoft.com/en-us/microsoft-365/compliance/search-the-audit-log-in-security-and-compl...

@Vasil Michev 

 

Thank you. Can we access this information from the Audit log using API's?  Can we get this data in Power BI? Any advice?  

 

Appreciate your help on this 

 

Thanks

Yes and yes... read the article!

Thank you !!