cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Common Data Service Audit data

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? 

5 REPLIES 5
Highlighted

Re: Common Data Service Audit data

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".

Highlighted
Memorable Member
Memorable Member

Re: Common Data Service Audit data

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!

Highlighted
Continued Contributor
Continued Contributor

Re: Common Data Service Audit data

Note that there are 2 levels of audit data.

  1. 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
  2. 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
Highlighted
Memorable Member
Memorable Member

Re: Common Data Service 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>"}

 

Highlighted
Advocate II
Advocate II

Re: Common Data Service Audit data

Thanks everyone. I will check it out.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,555)