web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... How to query in SQL ta...

Customer experience | Sales, Customer Insights,...

Suggested Answer

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

Report

Posted on by Emilius

5

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 Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

11manish 88 Super User 2026 Season 2

#2

Muhammad Shahzad Sh... 35 Most Valuable Professional

#3

Daniyal Khaleel 34 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans