web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by 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)
  • Daniel Cai Profile Picture
    935 on at
    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 Profile Picture
    193 on at
    RE: How to retrieve (and export) audit details of an "Delete" event?

    Hi Satishi,

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

  • JZot Profile Picture
    193 on at
    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.

    pastedimage1588899780474v1.png

    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)

    pastedimage1588899903838v2.png

    pastedimage1588899965846v3.png

  • Suggested answer
    KingswaySoft Profile Picture
    545 on at
    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:

    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 Profile Picture
    on at
    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/ 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 100 Super User 2025 Season 2

#2
Suresh Kulla Profile Picture

Suresh Kulla 72 Super User 2025 Season 2

#3
DAnny3211 Profile Picture

DAnny3211 54

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans