D365 Audit Logs viewing

(1) Share

Report

Posted on by gman0104

821

I have just recently migrated from CRM2011 to D365 online and have a request from our customer that they want to view all historical audit logs previously captured in CRM2011. There are over 150Million audit records across multiple entities and i would like some guidance too the best way to achieve this. I have experimented with KingswaySoft into a virtual table and while this does extract the data from the audit table there would seem to be quite a bit of work to do in relation to the number of lookups i would have to create for each entity that was audited (200 plus).

Has anyone any advise or pointers in how i could maybe take the current audit database and export it to a virtual table for it to be queried like it does currently.

Many thanks Gman76