Export All Audit history from Dynamics 365

(1) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (13)

Answers (0)

ashlega 34,477 on at

Like (0)

Report

Hi,

I don't think there are too many options.. you can also write your own code - here is an example from Microsoft:

msdn.microsoft.com/.../gg309735.aspx

Was this reply helpful? Yes No
Antbutcher 387 on at

Like (0)

Report

FYI - I tried using the "MSCRM Toolkit Audit Export Manager" today for the first time since we upgrade to 8.2 and it doesn't appear to work. There doesn't appear to an update available either.

Was this reply helpful? Yes No
Srujan K 317 on at

Like (1)

Report

You can use Data Export Services and Export complete Audit History Data to SQL Azure.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report

Hello,

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

KingswaySoft works both onprem and online.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Emad Hanna on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report

Have you tried Audit History Extractor plugin on XrmToolBox

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

Was this reply helpful? Yes No