Notifications
Announcements
No record found.
I need to create a report using SQL of audit history for a specific entity and a specific field in the entity (old value vs new value) is it possible? I'm using on-premisse 2016
Hi,
yes, it's possible.
Here's a link to help you write down a query to extract data:
https://community.dynamics.com/crm/b/mscrmcustomization/posts/ms-crm-audit-database-table-details
Also you can use some XrmToolbox plugin such as :
https://www.xrmtoolbox.com/plugins/AuditHistoryExtractor/
https://www.xrmtoolbox.com/plugins/MESquare.XrmToolBox.AuditExplorer/
https://www.xrmtoolbox.com/plugins/BDK.XrmToolBox.UserAuditViewer/
Hope it helps,
Marco
Hello,
I recommend you use the SDK as described here: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/retrieve-and-delete-the-history-of-audited-data-changes
If you want more info about the audit table, you could check here:
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/entities/audit
My recommendation is use the SDK.
Regards
Take a look:
marcuscrast.wordpress.com/.../
community.dynamics.com/.../using-audit-history-in-ssrs-reports
Basically you will use ChangeData columns of AuditHistory table.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 170 Super User 2025 Season 2
#ManoVerse 61
Gerardo RenterÃa Ga... 52 Most Valuable Professional
