How to Read or Report on CRM Online Audit Data? Audit ChangeData not readable via FetchXml! RRS feed

  • Question

  • Hi,

    We need to read/report on the CRM Audit data from a CRM Online instance. I tried to use FetchXml which does return all the audit records, but it omits the crucial "changedata" attribute which actually audits the data. I checked the metadata for the Audit entity and the "changedata" field is marked as not valid for Read! This is typical Microsoft crazy nonsense.

    So we have an audit trail but can't do anything with it. We have a requirement to create a report to show the customer the data that has been changed. Since this is CRM Online we can't use SQL & have to use FetchXml. But it seems FetchXml won't allow us to get the field we most need.

    I see there are SDK messages like RetrieveAuditDetailsRequest which allow you to get at the data, so why can't we use fettchxml? The SDK messages are of no use for creating a report.

    The only way I can see to do this is to develop a bespoke program that uses the SDK to download the audit data to a SQL table and report from that. But for a customer who is totally online that means having to spin up Azure machines & Azure SQL just to do a little admin job.

    How do other people manage to do this?

    • Edited by Caratacus Thursday, December 11, 2014 10:22 AM
    Thursday, December 11, 2014 10:22 AM

All replies

  • Hi, 

    There are few ways to bypass this strange CRM Online limitation (lack of access to Audit Database). 

    For small clients it's more then enough to use one of tools which you can download from Codeplex:


    One of the feature of this tool allows you to export Audit based on specific criteria.

    Kind regards.


    My Dynamics CRM Blog: http://bovoweb.blogspot.com

    Thursday, December 11, 2014 4:52 PM
  • Thanks for the link. This looks as if it could be useful without having to write our own Audit export tool.
    Monday, December 15, 2014 12:35 PM