Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Export "Audit Summary View"

  • 1.  Export "Audit Summary View"

    SILVER CONTRIBUTOR
    Posted Sep 12, 2019 02:40 PM
    Hello.
    I have CRM365 online, and I need to export "Audit Summary View".
    Any idea?
    Thanks

    ------------------------------
    Mohamad Idlepi
    CRM Development Manager
    Cineplex Inc.
    Toronto ON
    ------------------------------
    Conference-CRMUG_200x200


  • 2.  RE: Export "Audit Summary View"

    Posted Sep 13, 2019 02:58 AM
    Hi Mohamad

    This post explains how to export the audit logs from Dyn365 using Kingswaysoft.

    https://www.powerobjects.com/blog/2016/10/11/ssis-kingswaysoft-adapter-audit-information/


    ------------------------------
    Nick Doelman
    Microsoft MVP
    Dynamics 365 Specialist
    Nick Doelman Co.
    ottawa ON
    ------------------------------

    Conference-CRMUG_200x200


  • 3.  RE: Export "Audit Summary View"

    MICROSOFT MVP
    Posted Sep 13, 2019 04:39 AM
    Hi Mohamad,

    Another option is the XrmToolBox Audit History Extractor to export the audit records to a spreadsheet.  This would be a one-off manual task however, so if you need to do it regularly you'll want to look at KingswaySoft as @Nick Doelman says.

    Cheers,
    Andrew.​

    ------------------------------
    Andrew Bibby
    Dynamics 365 Consultant & Project Adviser
    Evesham, UK
    ------------------------------

    Conference-CRMUG_200x200


  • 4.  RE: Export "Audit Summary View"

    Posted Sep 13, 2019 11:09 AM
    You can also access the data via PowerBi (entity is audit).  Lots of options, just depends on your use case for the data.

    ------------------------------
    Sandra Devin
    CRM Analyst
    National CineMedia
    ------------------------------

    Conference-CRMUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role