Skip to main content

Notifications

Customer Service forum
Suggested answer

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

Posted on by 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

  • Daniel Cai Profile Picture
    Daniel Cai 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
    JZot 185 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
    JZot 185 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
    KingswaySoft 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
    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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans