Hi twinkle,
For CRM 2011 check the following link http://blogs.infinite-x.net/2011/05/02/crm-2011-exploring-bulk-delete-operations/
for CRM 4.0 You can write a console application using the crm sdk like,
static void runBulkDelete(CrmService service)
{
// Create a query expression using the QueryExpressionHelper
QueryExpressionHelper expression = new QueryExpressionHelper("asyncoperation");
expression.Columns.AddColumn("asyncoperationid");
expression.Criteria.Conditions.AddCondition("statecode", ConditionOperator.Equal, (int)AsyncOperationState.Completed);
expression.Criteria.Conditions.AddCondition("completedon", ConditionOperator.OlderThanXMonths, 1);
expression.Criteria.Conditions.AddCondition("operationtype", ConditionOperator.NotEqual, (int)AsyncOperationType.Import);
Guid[] emptyRecipients = new Guid[0];
BulkDeleteRequest request = new BulkDeleteRequest();
request.JobName = "Bulk delete completed asyncoperations to free up space";
request.QuerySet = new QueryBase[] { expression.Query };
request.ToRecipients = emptyRecipients;
request.CCRecipients = emptyRecipients;
request.SendEmailNotification = false;
request.RecurrencePattern = string.Empty;
request.StartDateTime = CrmDateTime.Now;
BulkDeleteResponse response = (BulkDeleteResponse)service.Execute(request);
Console.WriteLine("Bulk delete job with id: {0} has been created", response.JobId);
Console.ReadLine();
}
Regards,
