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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
Highlighted
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
Highlighted
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...

Highlighted

@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

Highlighted

Yes and yes... read the article!

Highlighted
Thank you !!