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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ManoVerse 180 Super User 2026 Season 1
11manish 123
CU11031447-0 100
