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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (