DeleteAuditDataRequest Class
Collapse the table of content
Expand the table of content

DeleteAuditDataRequest Class

Contains the data that is needed to delete all audit data records up until a specified end date. For the Web API use the DeleteAuditData Action.

Namespace: Microsoft.Crm.Sdk.Messages
Assembly: Microsoft.Crm.Sdk.Proxy (in Microsoft.Crm.Sdk.Proxy.dll)

public sealed class DeleteAuditDataRequest : OrganizationRequest

The following example shows how to use this message. For this sample to work correctly, you must be connected to the server to get an IOrganizationService interface. For the complete sample, see the link later in this topic.

// Get the list of audit partitions.
RetrieveAuditPartitionListResponse partitionRequest =
    (RetrieveAuditPartitionListResponse)_service.Execute(new RetrieveAuditPartitionListRequest());
AuditPartitionDetailCollection partitions = partitionRequest.AuditPartitionDetailCollection;

// Create a delete request with an end date earlier than possible.
DeleteAuditDataRequest deleteRequest = new DeleteAuditDataRequest();
deleteRequest.EndDate = new DateTime(2000, 1, 1);

// Check if partitions are not supported as is the case with SQL Server Standard edition.
if (partitions.IsLogicalCollection)
    // Delete all audit records created up until now.
    deleteRequest.EndDate = DateTime.Now;

// Otherwise, delete all partitions that are older than the current partition.
// Hint: The partitions in the collection are returned in sorted order where the 
// partition with the oldest end date is at index 0.
    for (int n = partitions.Count - 1; n >= 0; --n)
        if (partitions[n].EndDate <= DateTime.Now && partitions[n].EndDate > deleteRequest.EndDate)
            deleteRequest.EndDate = (DateTime)partitions[n].EndDate;

// Delete the audit records.
if (deleteRequest.EndDate != new DateTime(2000, 1, 1))
    Console.WriteLine("Audit records have been deleted.");
    Console.WriteLine("There were no audit records that could be deleted.");

Message Availability

For this message to work, the caller must be connected to the server.


Pass an instance of this class to the Execute method, which will return an instance of DeleteAuditDataResponse.

Privileges and Access Rights

For a list of the privileges required, see DeleteAuditData Privileges.

Notes for Callers

This message behaves slightly different depending on the version of Microsoft SQL Server that is installed on the Microsoft Dynamics CRM server. See Retrieve and Delete the History of Audited Data Changes for more information.


Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.



Windows Server 2008,Windows Server 2012,Windows 7

Send comments about this topic to Microsoft.
© 2015 Microsoft. All rights reserved.

Community Additions

© 2016 Microsoft