Search code examples
dynamics-crm-2011dynamics-crm

How to export Audit Summary View in MS Dynamics CRM 2011


Under 'Settings' -> 'System' -> 'Auditing' -> 'Audit Summary View' , how to export the data into an excel spreadsheet? There is no export option. Only Advanced Find that does not help me export the data I want.

Help would be appreciated!

Thanks!


Solution

  • You don't - Microsoft hasn't exposed the export functionality for audit data - potentially because of how it is stored in the database (XML blobs)

    If you have development skills, you could use the SDK to retrieve values: Sample: Audit Entity Data Changes

    Otherwise if you are On Premise - you could see about creating a SSRS report. CRM 2011 - reports on data auditing