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

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

(1) Share

Report

Posted on by JZot

193

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Satish Tiwari - CRM Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Suggested answer

KingswaySoft 545 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
JZot 193 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
JZot 193 on at

Like (0)

Report
Copy link

Link copied!

Hi Satishi,

Auditt History Extractor doesn't track "Delete" events. Thanks

Was this reply helpful? Yes No
Daniel Cai 935 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No