How to fetch CRM Dynamic Application Audit Logs from MS Purview through Azure Databricks?

Question

Hi,

We are looking to fetch AuditLogs of Dynamics CRM from MS Purview through Azure Databricks. I know we can fetch through 'Microsoft Graph Rest API beta version' but in the page linked below it said it is not supported for Production environment.

https://learn.microsoft.com/en-us/graph/api/resources/security-auditlogquery?view=graph-rest-beta

I checked for the feature in Microsoft Graph API v1.0 and seems like its not available.
Please suggest me alternatives to fetch the CRM Application AuditLogs from MS Purview.
Also let me know if more details needed to understand and propose any approach.

Thanks
Kalyani

Answer 1

Your best option is the Management activities API: https://learn.microsoft.com/en-us/office/office-365-management-api/office-365-management-activity-api-reference

If for some reason you need a PowerShell-based solution, use the Exchange Online module and the Search-UnifiedAuditLog cmdlet search instead of the Graph one: https://learn.microsoft.com/en-us/powershell/module/exchange/search-unifiedauditlog?view=exchange-ps