web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) MS CRM 2013 Audit Hist...

Microsoft Dynamics CRM (Archived)

MS CRM 2013 Audit History in sqlserver query

(0) Share

Report

Report

Posted on by Suresh Sorde

1,077

Hi,

I need to query incident with audit table to get old and new value.

But when I check audit table, not able to find old value field and new value field.

Please help me to find audit history old value and new value fields in SQL Server Query.

6835.Audit.png

Thanks

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: MS CRM 2013 Audit History in sqlserver query

Its really not nice the way it is held in the db, but this should point you in the right direction

a33ik.blogspot.co.uk/.../crm-2011-reports-on-data-auditing.html

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (0)

Report

RE: MS CRM 2013 Audit History in sqlserver query

This is a good start - http://a33ik.blogspot.co.uk/2011/11/crm-2011-reports-on-data-auditing.html#more . Be aware that the audit table will only store the previous values, not the new values. The new values will either be in a more recent audit record, or the current data

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

Community Member 2

#2

Christoph Pock 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans