Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

How I Get What Changed In a Audit Register

Posted on by 250

Hello Everyone, my name is Taniguchi and i building an power bi with the audit records filtering only the segurity role entity because i want to exib in power bi who modified the security role and what was changed and when i enter in a audit register it shows a table or a associated record and i wish to show this in power bi. How can I access this table or the associated record.

pastedimage1625852196249v1.png

How can i get this table ?

pastedimage1625852253801v2.png

How can i get this associated record ?

  • Suggested answer
    RE: How I Get What Changed In a Audit Register

    Hi Tani Santos,

    do the below Web API functions help you achieve your goal?

    docs.microsoft.com/.../retrieveauditdetails

    docs.microsoft.com/.../retrieverecordchangehistory

    Some example queries of mine:

    Assuming a security role record I want to query on = 5b57f61f-ff3b-e911-a820-000d3ab46296:

    /api/data/v9.1/RetrieveRecordChangeHistory(Target=@Target)?@Target={%22roleid%22:%225b57f61f-ff3b-e911-a820-000d3ab46296%22,%22@odata.type%22:%22Microsoft.Dynamics.CRM.role%22}

    /api/data/v9.1/audits?$filter=_objectid_value eq 5b57f61f-ff3b-e911-a820-000d3ab46296 (here you can get the auditid for use on below query)

    /api/data/v9.1/audits(958858db-afe3-eb11-a7ad-281878af6700)/Microsoft.Dynamics.CRM.RetrieveAuditDetails()

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans