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?
