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?
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".
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-odat...
Hope this helps!
Note that there are 2 levels of audit data.
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>"}
Thanks everyone. I will check it out.
User | Count |
---|---|
18 | |
9 | |
8 | |
5 | |
5 |
User | Count |
---|---|
31 | |
27 | |
18 | |
15 | |
4 |