Microsoft Dynamics 365 helps Audit Logging of assorted occasions. Approved customers can view the Audit Historical past on any Dynamics 365 tables enabled for Auditing.
Nonetheless, there may be NO Export audit information operate obtainable from the Dynamics 365 Audit Historical past or Audit Abstract View.
The excellent news is that there’s an out of the field possibility through Microsoft 365 Compliance’s Audit to Export the Dynamics 365 audit data together with the Modified Values.
Right here is an instance from the Microsoft Dynamics 365 Audit Historical past displaying a Create and two Updates for “Take a look at Contact 210409” file: Discover that there’s NO choice to export this information from the Dynamics 365 Contact’s Audit Historical past view.
Now let’s take a look at this consequence from the Microsoft 365 compliance Audit Search on Dynamics 365 actions. Discover that there’s the choice to Obtain all outcomes!
The Obtain is a CSV file. Discover that column D “AuditData” is in JSON format.
Excel has the choice to remodel/format the column JSON to common Excel columns utilizing Power Query Editor. Here’s a link to the steps to format the exported audit log
After the rework and growth of the AuditData columns. Then one other stage growth of the AuditData.Fields column yielded the Audit Historical past Subject values in a fairly normal and straightforward to investigate Excel format:
Notice: Dynamics 365 Audit Log information IS NOT instantly obtainable in Microsoft 365 Compliance – takes up to 24 hours AFTER the occasion happens for the corresponding audit log file to be returned
Contact me should you want some Microsoft Dynamics 365 CRM Gross sales Buyer Engagement help.
Frank Lee
12 occasions awarded Microsoft MVP – Dynamics 365 / CRM
San Francisco Bay Space | Silicon Valley
