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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No