web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer Service forum / Building SSRS Report t...
Customer Service forum

Building SSRS Report to export audit history of an entity's record on a ribbon button click D365 online

(0) ShareShare
ReportReport
Posted on by abhinav.dodda 5

Hello Everyone,

I have a quick question, can we build SSRS report to get audit history on a particular entity's record using fetch xml in d365 online?

If Yes, could some one please send me the steps on how to do it?

This is of a little urgency, could some one get back to me quickly please?

Categories:
Other
I have the same question (0)
  • Suggested answer
    LuHao Profile Picture
    LuHao 40,892 on at

    Hi partner,

    If you want to export audit records for a particular entity record, the easiest way is to use the Audit History Extractor of XrmToolBox.

    This is the download site for XrmToolBox: https://www.xrmtoolbox.com/

    This is the basic use of XrmToolBox: https://community.dynamics.com/crm/b/krmkyliesresearchmanagement/posts/getting-started-with-xrm-toolbox

    This is the project web site of the Audit History Extractor and its tutorial:https://github.com/alduzzen1985/Audit-History-Extractor

    After downloading and unzipping XrmToolBox, connect to your D365 organization and download the Audit History Extractor in the plugin store.

    Open the Audit History Extractor, click Get Entities to select an entity. 

    1. You could choose to filter out the entity records you want to query by view, so you need to create a new personal view in D365 first.

    2. Or you could filter the entity records through Fetchxml, so you need open the advanced find in D365 to set the filter condition, then export its Fetchxml, and then copy it into the Audit History Extractor.

    8640.PNG

    Finally, export the audit of the query to Excel.

  • LuHao Profile Picture
    LuHao 40,892 on at

    Hi partner,

    Please don't forget to close this theme by clicking Yes to mark the verified answer.

    pastedimage1566892777106v1.png

    This will help other users quickly navigate to this theme.

    Thanks.  :)

  • Suggested answer
    Pawar Pravin Profile Picture
    Pawar Pravin 5,237 on at

    Please refer below url for reference, I think you are looking somewhat related:

    community.dynamics.com/.../audit-log-report

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans