SOLVED

Echange Online Auditing - Non Owner Mailbox Access Report

%3CLINGO-SUB%20id%3D%22lingo-sub-2609087%22%20slang%3D%22de-DE%22%3EEchange%20Online%20Auditing%20-%20Non%20Owner%20Mailbox%20Access%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2609087%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20get%20the%20Non%20Owner%20Mailbox%20Access%20report%20using%20Powershell%20for%20one%20Month%20for%20some%20large%20Exchange%20Online%20environments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20using%20%22Search-UnifiedAuditLog%22%20as%20well%20as%20performing%20a%20%22Search-MailboxAuditLog%22%20is%20extremly%20slow%20and%20even%20leads%20to%20Throttling.%20Therefor%20performing%20the%20Search%20for%20thousands%20of%20Mailboxes%20where%20the%20report%20is%20required%20for%20requires%20a%20lot%20of%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20do%20this%20from%20within%20PowerShell%20(as%20it's%20part%20of%20a%20reporting%20%22Suite%22)%20to%20be%20able%20exporting%20it%20to%20CSV%2FExcel%20in%20an%20easier%20way%3F%3C%2FP%3E%3CP%3ECan%20this%20be%20achieved%20using%20the%20Graph%20API%20Module%20for%20PowerShell%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20Help%20and%20best%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2609765%22%20slang%3D%22en-US%22%3ERe%3A%20Echange%20Online%20Auditing%20-%20Non%20Owner%20Mailbox%20Access%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2609765%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20afraid%20there%E2%80%99s%20no%20easier%20way.%20Searching%20the%20audit%20log%20has%20always%20been%20very%20slow.%20You%20may%20want%20to%20see%2C%20depending%20on%20how%20much%20audit%20data%20is%20being%20generated%2C%20to%20just%20export%20all%20data%20and%20filter%20yourself.%20I%E2%80%99ve%20experienced%20slow%20downs%20when%20the%20filtering%20needs%20to%20be%20done%20server%20side.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don%E2%80%99t%20recall%20seeing%20any%20Graph%20API%20actions%20for%20this.%20There%20is%20the%20Office%20365%20Management%20APIs%20which%20provide%20access%20to%20audit%20logs%2C%20but%20this%20is%20more%20geared%20towards%20subscription%20based%20near%20real%20time%20monitoring.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2609806%22%20slang%3D%22de-DE%22%3ERe%3A%20Echange%20Online%20Auditing%20-%20Non%20Owner%20Mailbox%20Access%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2609806%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960791%22%20target%3D%22_blank%22%3E%40pvanberlo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20Thank%20you%20for%20your%20Reply.%20I'll%20try%20to%20export%20without%20filtering%20thank%20you%20for%20the%20hint!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I need to get the Non Owner Mailbox Access report using Powershell for one Month for some large Exchange Online environments.

 

Unfortunately using "Search-UnifiedAuditLog" as well as performing a "Search-MailboxAuditLog" is extremly slow and even leads to Throttling. Therefor performing the Search for thousands of Mailboxes where the report is required for requires a lot of time.

 

Is there a way to do this from within PowerShell (as it's part of a reporting "Suite") to be able exporting it to CSV/Excel in an easier way?

Can this be achieved using the Graph API Module for PowerShell?

 

Thank you for your Help and best regards

2 Replies
best response confirmed by Trevor_Rusher (Community Manager)
Solution
I’m afraid there’s no easier way. Searching the audit log has always been very slow. You may want to see, depending on how much audit data is being generated, to just export all data and filter yourself. I’ve experienced slow downs when the filtering needs to be done server side.

I don’t recall seeing any Graph API actions for this. There is the Office 365 Management APIs which provide access to audit logs, but this is more geared towards subscription based near real time monitoring.

@pvanberlo 

Hi, Thank you for your Reply. I'll try to export without filtering thank you for the hint!