Originally posted on Microsoft Dynamics 365 CRM Blog:
Microsoft Dynamics 365 supports Audit Logging of various events. Authorized users can view the Audit History on any Dynamics 365 tables enabled for Auditing. However, there is NO Export audit data function available from the Dynamics 365 Audit History or Audit Summary View. The good news is that…
Continue Reading Nishant Rana’s Article on their blog
How to Export the Audit History Values from Dynamics 365
Requirements for Audit with Compliance Center https://docs.microsoft.com/en-us/power-platform/admin/enable-use-comprehensive-auditing#requirements Requirements A Microsoft 365 Enterprise E3 or E5 subscription is required to do Activity Logging. Available for production and not sandbox environments. Also check – https://github.com/alduzzen1985/Audit-History-Extractor http://www.kingswaysoft.com/blog/2019/10/16/Extracting-Audit-Logs-for-Multiple-CRM-Entities https://nishantrana.me/2018/10/08/using-kingswaysofts-cds-crm-source-component-to-get-audit-information-in-dynamics-365-ce-ssis/ Use SQL 4 CDS XrmToolbox tool to run query again Audit table – https://markcarrington.dev/sql-4-cds/
Blog Syndicated with Nishant Rana’s Permission