Microsoft Dynamics 365 supports Audit Logging of various events. Authorized users can view the Audit History on any Dynamics 365 tables enabled for Auditing.
However, there is NO Export audit data function available from the Dynamics 365 Audit History or Audit Summary View.
Here is an example from the Microsoft Dynamics 365 Audit History showing a Create and two Updates for “Test Contact 210409” record: Notice that there is NO option to export this data from the Dynamics 365 Contact’s Audit History view.
Now let’s look at this result from the Microsoft 365 compliance Audit Search on Dynamics 365 activities. Notice that there is the option to Download all results!
The Download is a CSV file. Notice that column D “AuditData” is in JSON format.
After the transform and expansion of the AuditData columns. Then another level expansion of the AuditData.Fields column yielded the Audit History Field values in a pretty standard and easy to analyze Excel format:
Contact me if you need some Microsoft Dynamics 365 CRM Sales Customer Engagement assistance.
12 times awarded Microsoft MVP – Dynamics 365 / CRM
San Francisco Bay Area | Silicon Valley