You’re offline. This is a read only version of the page.
645
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
Take a look:
marcuscrast.wordpress.com/.../
community.dynamics.com/.../using-audit-history-in-ssrs-reports
Basically you will use ChangeData columns of AuditHistory table.
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
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
#1
Daivat Vartak (v-9d...
225
Super User 2025 Season 1
#2
Muhammad Shahzad Sh...
106
Most Valuable Professional
#3
Eugen Podkorytov
102
Share
Report
All responses (
Answers (
