SBX - Search With Button

SBX - Forum Post Title

Export All Audit history from Dynamics 365

Microsoft Dynamics CRM Forum

Lahcen asked a question on 10 Jul 2017 8:14 AM
My Badges

Question Status

Suggested Answer

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.

Reply
Alex Shlega responded on 10 Jul 2017 8:46 AM
My Badges

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

Reply
Antony Butcher responded on 15 Dec 2017 7:42 AM
My Badges

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.

Reply
Srujan Konjarla responded on 16 Dec 2017 3:23 AM
My Badges

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

Reply
cjjohnson responded on 14 Feb 2018 2:17 PM

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

Reply
Suggested Answer

Hello,

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

Reply
cjjohnson responded on 14 Feb 2018 3:16 PM

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.

Reply
Suggested Answer

KingswaySoft works both onprem and online.

Reply
mini goblin responded on 14 Feb 2018 7:08 PM

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

Reply
Bill Hanna responded on 3 Apr 2019 12:30 PM

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

Reply
Suggested Answer

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

Reply
mini goblin responded on 3 Apr 2019 9:10 PM

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

Reply
Srujan Konjarla responded on 23 Apr 2019 5:40 AM
My Badges
Suggested Answer

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

Reply
Suggested Answer

Hello,

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

Reply
Suggested Answer

KingswaySoft works both onprem and online.

Reply
Suggested Answer

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

Reply
Srujan Konjarla responded on 23 Apr 2019 5:40 AM
My Badges
Suggested Answer

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

Reply

SBX - Two Col Forum

SBX - Migrated JS