Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Export All Audit history from Dynamics 365

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I have a requirement to export the audit history from Dynamics 365 to an external application. There is no out of the box way to export the audit history in CRM. The export should also be scheduled to run every X hours, and export the delta changes.

Apart from the MSCRM Toolkit Audit Export Manager (which I am not sure It works for Dynamics 365 ?), what are the other approches we this task ? We cannot access directly the SQL DB from Dynamics 365.

Thank you,

Lahcen.

*This post is locked for comments

  • RE: Export All Audit history from Dynamics 365

    Has anything moved on in this one since the last post? We've got the same problem of wanting to extract audit data out of Dynamics.

  • Suggested answer
    Srujan K Profile Picture
    Srujan K 317 on at
    RE: Export All Audit history from Dynamics 365

    Sorry Chris , DES does not expose Audit , Please try using an Azure Logic App

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export All Audit history from Dynamics 365

    XRM Tool Box Plugin was glitchy, especially for big audit history it can not be used

  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,050 on at
    RE: Export All Audit history from Dynamics 365

    Have you tried Audit History Extractor plugin on XrmToolBox

    ScreenClip-_5B00_432_5D00_.png

    ScreenClip-_5B00_432_5D00_.png

    it the plugin works as you expected, I don't see why you can't have a look at the code and see if you could push this into a scheduled Azure function and insert into Blob or Azure SQL or CosmosDB

    https://github.com/alduzzen1985/Audit-History-Extractor

    With the Change Tracking feature in CRM, the external system can get the as and when something changes in CRM entity records so you could build an Azure based audit table using changes tracking feature

    And with the new O365 Security and Compliance Center, audit history is synced to O365 so it might be worth having a look at that as well

    https://docs.microsoft.com/en-us/office365/securitycompliance/search-the-audit-log-in-security-and-compliance

  • Emad Hanna Profile Picture
    Emad Hanna on at
    RE: Export All Audit history from Dynamics 365

    Did anyone figure this out?  I need to extract the audit history into tables.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export All Audit history from Dynamics 365

    You can used Power Shell script with Azure automation account , that will run updated script  every X hours

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Export All Audit history from Dynamics 365

    KingswaySoft works both onprem and online.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export All Audit history from Dynamics 365

    Hi Andrew - thank you for the reply.  I attempted to do this with Scribe, but the "changedata" field couldn't be read (I'm accessing D365 Online).  I hadn't tried Kingswaysoft yet.  In your link, it shows a great example, but it is connecting to CRM On Prem.  Do you know if Kingsway is able to pull the changedata field?  Naturally with On prem it can be done because of a local database, but my challenge has been getting this information from Online.  I could always write something using the SDK but was hoping to leverage a tool if possible.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Export All Audit history from Dynamics 365

    Hello,

    I would suggest to use KingswaySoft Integration toolkit for that purpose - blog.sonomapartners.com/.../analyzing-audit-logs-using-kingswaysoft.html

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Export All Audit history from Dynamics 365

    Srujan - you mentioned using Data Export Services and Export complete Audit History to SQL Azure.  I've installed and am able to export any entity from D365 to SQL Azure, but I don't see the option to export the complete audit history.  Can you direct me to how to do this?  Thank you!

    Chris

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans