Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics 365 Audit Tra...
Microsoft Dynamics CRM (Archived)

Dynamics 365 Audit Trail SSRS Report row view (Old and new Value)

(0) ShareShare
ReportReport
Posted on by Ahmed Ghaib 107

Hello Guys , 

I've been struggling two days ago but , not reached to the desired result.

Our Customer needs to have SSRS report for all audit trail in rows view for each entity and field new , old value 

He did not want to use the Audit summary view as he wants to see all changes in the same grid ( inline)

so for example 

Date      Entity Name      Field                 Old value   New Value

1/1/2018   contact           First Name      John            John1

1/1/2018   contact           Last Name       Smith          Smith1

...

...

...1/1/2018   Account          Telephone     telepon1   Telephone2

I've googled it , but people talking about enabling this for specific fields and specific entity using the entity fields self.

and I couldn't parse the changed data to understand the old and new values.

I'd like to get  old and new value in the single row 

How Can I do that ??

Thanks ,

*This post is locked for comments

  • JandostKhoso Profile Picture
    JandostKhoso 266 on at
    RE: Dynamics 365 Audit Trail SSRS Report row view (Old and new Value)

    You will need to send Audit Messages such as RetrieveAuditDetailsRequest and RetrieveAttributeChangeHistoryRequest and write your own custom code.

  • Ahmed Ghaib Profile Picture
    Ahmed Ghaib 107 on at
    RE: Dynamics 365 Audit Trail SSRS Report row view (Old and new Value)

    Thanks for your reply

    is there anyway to write Sql query to translate changed data to old and new value

  • JandostKhoso Profile Picture
    JandostKhoso 266 on at
    RE: Dynamics 365 Audit Trail SSRS Report row view (Old and new Value)

    Unfortunately the platform does not provide sophisticated reporting for Audits.

    There are Audit messages in the SDK which you can use to retrieve Audit information and then format the output. It will require some development effort but you will have the complete flexibility to get the data you want, the way you want it.

    There is Audit Summary Reporting tool in XRMToolbox which is very helpful and you can extract audit data in csv format.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans