How to query in SQL tables of Dynamics 365 on premises for audit changes of specific field by old and new value

(0) Share

Report

Posted on by Emilius

I need to query Audit log information like " When and by whom the Field1 was changed from "oldValue1" to "NewValue1" ". This should be done in SQL database of Dynamics 365 on premises.

I have found Audit table, but I can not find in it information on filed name and new value, can someone help me with that? Thanks in advance

All responses (1)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

RE: How to query in SQL tables of Dynamics 365 on premises for audit changes of specific field by old and new value

Hello,

You can check my 11-year-old article - a33ik.blogspot.com/.../crm-2011-reports-on-data-auditing.html

I haven't revisited it for a while but I believe it still can be applicable with some modifications.