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.
I don't think there are too many options.. you can also write your own code - here is an example from Microsoft:
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.
You can use Data Export Services and Export complete Audit History Data to SQL Azure.
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!
I would suggest to use KingswaySoft Integration toolkit for that purpose - blog.sonomapartners.com/.../analyzing-audit-logs-using-kingswaysoft.html
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.
KingswaySoft works both onprem and online.
You can used Power Shell script with Azure automation account , that will run updated script every X hours
Did anyone figure this out? I need to extract the audit history into tables.
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
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
XRM Tool Box Plugin was glitchy, especially for big audit history it can not be used
Sorry Chris , DES does not expose Audit , Please try using an Azure Logic App
Business Applications communities