Hi!
We are using Dynamics CRM online.
We need to capture and export all of the "audit details" (meaning the field and its values) of each of the deleted record. Please see screenshots below. Is this possible in any way? I've tried in "Create" and "Update" operation, I can query it in fetchxml builder thru linkentity but for some reason it is not possible with "Delete".
Also with KingswaySoft, it can only extract the details of the audit record (attribute change etc..) itself but not the record field values. Can someone has any idea or any workaround? Thank you!
Unlike update operation, CRM deletion audit doesn't have any field value details.
Hi Satishi,
Auditt History Extractor doesn't track "Delete" events. Thanks
Hi KingswaySoft!
Thanks for the reply!
I've tried to use the fetchxml query your provided above in Dynamics CRM Source.
But the retrieved details are just audit details (see first screenshot below) and not the actual field values of the deleted record (see second screenshot below)
In order to get your deleted records and their details using our toolkit, you should query against the “audit” entity itself in our CRM Source Component. So for example, to get the records which were deleted today, your FetchXML query can look like this:
The 'operation' attribute specifies the action taken by the user, for your case, you can choose ‘3’ which is Delete. You can refer to Microsoft documentation at the link below to learn more regarding all the available actions and operations codes:
Finally, you will find the full details of the deleted records in the “Audit Details (Attribute Changes)” output from your source component. These attribute changes can be related back to the original audit record through the auditid field.
If you have any more questions, please do not hesitate to reach out to our Support team.
Hello JZ,
You can try using Audit History Extractor from Xrm toolbox and see if it helps. You can download Xrm toolbox from here - https://www.xrmtoolbox.com/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154