Service | Customer Service, Contact Center, Fie...

How to retrieve (and export) audit details of an "Delete" event?

(1) Share

Report

Posted on by JZot

185

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".

1856.pastedimage1588816054325v2.png

7851.pastedimage1588816025987v1.png

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!

8664.pastedimage1588817018516v3.png

All responses (5)

Answers (0)

Daniel Cai 935 on at

Like (0)

Report

RE: How to retrieve (and export) audit details of an "Delete" event?

Unlike update operation, CRM deletion audit doesn't have any field value details.
JZot 185 on at

Like (0)

Report

RE: How to retrieve (and export) audit details of an "Delete" event?

Hi Satishi,

Auditt History Extractor doesn't track "Delete" events. Thanks
JZot 185 on at

Like (0)

Report

RE: How to retrieve (and export) audit details of an "Delete" event?

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)
Suggested answer

KingswaySoft 545 on at

Like (0)

Report
RE: How to retrieve (and export) audit details of an "Delete" event?

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:

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/entities/audit

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.
Suggested answer

Satish Tiwari - CRM on at

Like (0)

Report

RE: How to retrieve (and export) audit details of an "Delete" event?

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/