Unanswered

Common Data Service Audit data

(0) Share

Report

Posted on by barlowse

207

Does anyone have a way to get the audit data on CDS entities into a PowerBI report or even an Excel file? I know there are ideas already posted for something, but was looking for a workaround while we wait for it to be delivered OOTB. Is PowerShell an option?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report

Hi @barlowse

Have you looked at the Audit History Extractor plugin for XRMToolbox?

More info on the plugin here
https://github.com/alduzzen1985/Audit-History-Extractor

-----

If this post has answered your question please consider it for "Accept as Solution" or if it has been helpful give it a "Thumbs Up".

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Hi @barlowse,
Yes PowerShell is an option, you can get all the audit history data via the CDS's Rest API. You can consume that API with PowerShell or any method of your choice. Here's the base:
https://<env>.api.crm<6>.dynamics.com/api/data/v9.1/audits
For more info: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/audit?view=dynamics-ce-odata-9
Hope this helps!

Was this reply helpful? Yes No
David Jennaway 716 on at

Like (1)

Report
Note that there are 2 levels of audit data.
The audit entity (as per the previous post). This will give you the operation, user and date, but won't give the details of the attributes that changed
The attribute change history. This will give the attribute values. To get this, you need to call the RetrieveAttributeChangeHistory function, and you need to call this for each audit record. You could probably do this via PowerShell, but you'd need to write the logic to parse the results for the audit data, and loop through each in turn

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Thanks correct @DavidJennaway and can still consume with Rest API. Here's an exmaple entity Opportunity:
https://<env>.api.crm<6>.dynamics.com/api/data/v9.1/RetrieveRecordChangeHistory(Target=@t)?@t={"@odata.type":"Microsoft.Dynamics.CRM.opportunity","opportunityid":"<guid>"}

Was this reply helpful? Yes No
barlowse 207 on at

Like (1)

Report

Thanks everyone. I will check it out.

Was this reply helpful? Yes No