Deployment

10 ways to free storage space in Microsoft Dynamics CRM Online

These are ways to reduce the amount of storage space used by removing or deleting different types of of information from Microsoft Dynamics CRM Online. Use one or more of these methods to control your total data storage usage with Microsoft Dynamics CRM Online. You can delete certain categories of data as the need arises, or you can set up bulk deletion jobs to reoccur at set intervals.

Caution

The suggestions in this article include deleting notes, attachments, import history, and other data. You cannot retrieve deleted data. There is no “undo” to restore deleted data. This means it may make more sense for you to increase the amount of storage space you have with your Microsoft Dynamics CRM Online subscription instead of reducing the amount of storage space used.

Note

Except for methods 3 and 5, all these methods require that you have a Microsoft Dynamics CRM Online security role, such as System Administrator. This gives you permission to delete records in bulk and to delete system jobs.

On This Page

Method 1: Delete bulk e-mail and workflow instances using a bulk deletion job

Method 2: Evaluate and delete suspended workflows

Method 3: Remove e-mail attachments using Advanced Find

Method 4: Remove e-mail messages with attachments using a bulk deletion job

Method 5: Remove notes with attachments using Advanced Find

Method 6: Remove notes with attachments using a bulk deletion job

Method 7: Remove bulk duplicate detection jobs and associated copies of duplicate records

Method 8: Delete bulk import instances using a bulk deletion job

Method 9: Delete bulk deletion job instances using a bulk deletion job

Method 10: Delete audit logs

Method 1: Delete bulk e-mail and workflow instances using a bulk deletion job

Caution

If you delete this data, you will no longer be able to tell if an e-mail was sent through bulk e-mail or if a workflow rule ran against a record. The e-mails that were sent and the actions that ran against the record in the workflow will remain.

  1. Click Settings, click Data Management, click Bulk Record Deletion, and then in the menu bar, click New. This opens the Bulk Deletion Wizard.
  2. Click Next.
  3. In the Look for list, select System Job.
  4. In the search criteria area, add criteria similar to the following:

    System Job TypeEqualsBulk E-mail; Workflow;

    Status ReasonEqualsSucceeded

    Completed OnOlder Than X Months – 1

  5. Group the three criteria rows:
    1. Click the arrow next to each criteria row, and then click Select Row.
    2. With all three rows selected, click Group AND.
  6. Click Next.
  7. In the Name text box, type a name for the bulk deletion job.
  8. Select a date and time for the job start time; preferably a time when users are not in Microsoft Dynamics CRM Online.
  9. Select the Run this job after every check box, and then in the days list, select the frequency you want the job to run.
  10. If you want a notification e-mail sent, select the Send an e-mail to me (email@domain.com) when this job is finished check box.
  11. Click Next, review the bulk deletion job, and then click Submit to create the recurring job.

Method 2: Evaluate and delete suspended workflows

Sometimes workflows will enter a suspended state because there is a condition that will never be met or some other reason that will not allow the workflow to continue.

Caution

Some workflows will be in a suspended state because they are waiting for a condition that has not yet been met, which is expected. For example, a workflow may be waiting for a task to be completed.

  1. Click Advanced Find.
  2. In the Look for list, select System Jobs.
  3. In the search criteria area, add criteria similar to the following:

    System Job TypeEqualsWorkflow

    Status ReasonEqualsSuspended

  4. Group the three criteria rows:
    1. Click the arrow next to each criteria row, and then click Select Row.
    2. With all three rows selected, click Group AND.
  5. Click Find.
  6. In the results window, you can open each item to determine whether the workflow can be deleted.

Method 3: Remove e-mail attachments using Advanced Find

Caution

If you delete this data, the attachments will no longer be available in Microsoft Dynamics CRM Online. However, if you have them saved in Microsoft Office Outlook, they will still be there.

  1. Click Advanced Find.
  2. In the Look for list, select E-mail Messages.
  3. In the search criteria area, add criteria similar to the following:

    E-mail Attachments (Item)

    File Size (Bytes)Is Greater Than - In the text box, type a byte value, such as 25000.

  4. Click Find.
  5. You will now have a list of e-mail messages that have attachments that are larger than ‘X’ bytes.
  6. You can open each e-mail, click the Attachments tab, and delete each desired attachment.

    Note

    If you want to delete both the e-mail message and the attachment, select the record for the e-mail messages and then click Delete (X).

Method 4: Remove e-mail messages with attachments using a bulk deletion job

Caution

If you delete this data, the e-mail messages and their associated attachments will no longer be available in Microsoft Dynamics CRM Online. However, if you have them saved in Microsoft Office Outlook, they will still be there.

  1. Click Settings, click Data Management, click Bulk Record Deletion, and then in the menu bar, click New. This opens the Bulk Deletion Wizard.
  2. Click Next.
  3. In the Look for list, select E-mail Messages.
  4. In the search criteria area, add criteria similar to the following:

    Status ReasonEqualsCompleted

    Actual EndOlder Than X Months – 1

    E-mail Attachments (Item)

    File Size (Bytes)Is Greater Than – In the text box, type a byte value, such as 25000.

  5. Group the first two criteria rows:
    1. Click the arrow next to each criteria row, and then click Select Row.
    2. With both rows selected, click Group AND.
  6. Click Next.
  7. In the Name text box, type a name for the bulk deletion job.
  8. Select a date and time for the job start time; preferably a time when users are not in Microsoft Dynamics CRM Online.
  9. Select the Run this job after every check box, and then in the days list, select the frequency you want the job to run.
  10. If you want a notification e-mail sent, select the Send an e-mail to me (email@domain.com) when this job is finished check box.
  11. Click Next, review the bulk deletion job, and then click Submit to create the recurring job.

Method 5: Remove notes with attachments using Advanced Find

Caution

If you delete this data, notes and their associated attachments will no longer be available in Microsoft Dynamics CRM Online.

  1. Click Advanced Find.
  2. In the Look for list, select Notes.
  3. In the search criteria area, add criteria similar to the following:

    File Size (Bytes)Is Greater Than – In the text box, type a byte value, such as 1048576.

  4. Click Find.
  5. You will now have a list of attachments that are larger than the size you specified.
  6. Select individual or a multiple attachments, and then click Delete (X).

Method 6: Remove notes with attachments using a bulk deletion job

Caution

If you delete this data, notes and their associated attachments will no longer be available in Microsoft Dynamics CRM Online.

  1. Click Settings, click Data Management, click Bulk Record Deletion, and then in the menu bar, click New. This opens the Bulk Deletion Wizard.
  2. Click Next.
  3. In the Look for list, select Notes.
  4. In the search criteria area, add criteria similar to the following:

    File Size (Bytes)Is Greater Than – In the text box, type a byte value, such as 1048576.

    Created OnOlder Than X Months – 1

  5. Group the three criteria rows:
    1. Click the arrow next to each criteria row, and then click Select Row.
    2. With all three rows selected, click Group AND.
  6. Click Next.
  7. In the Name text box, type a name for the bulk deletion job.
  8. Select a date and time for the job start time; preferably a time when users are not in Microsoft Dynamics CRM Online.
  9. Select the Run this job after every check box, and then in the days list, select the frequency you want the job to run.
  10. If you want a notification e-mail sent, select the Send an e-mail to me (email@domain.com) when this job is finished check box.
  11. Click Next, review the bulk deletion job, and then click Submit to create the recurring job.

Method 7: Remove bulk duplicate detection jobs and associated copies of duplicate records

Every time that a duplicate detection job runs, a copy of each duplicate record is stored in the database as part of the duplicate detection job. For example, if you have 100 duplicate records, every time that you run a duplicate detection job that finds these duplicates, whether it is manual or reoccurring, those 100 duplicate records will be stored in the database under that instance of that duplicate job until the duplicates are merged or deleted, or until the instance of that duplicate detection job is deleted.

  1. Click Settings, click Data Management, and then click Duplicate Detection Jobs.
  2. Select the duplicate detection job instances you want to delete, and then click Delete (X).

To avoid wasting storage space, make sure duplicates are resolved promptly so that they are not reported in multiple duplicate detection jobs.

Method 8: Delete bulk import instances using a bulk deletion job

Every time you perform a bulk import, there is a system job associated with that import. The system job details show which records imported successfully and which records failed.

Caution

After you delete these bulk import jobs, you will not be able to see what data was imported and you cannot roll back the import.

  1. Click Settings, click Data Management, click Bulk Record Deletion, and then in the menu bar, click New. This opens the Bulk Deletion Wizard.
  2. Click Next.
  3. In the Look for list, select System Job.
  4. In the search criteria area, add criteria similar to the following:

    System Job TypeEqualsImport

    Status ReasonEqualsSucceeded

    Completed OnOlder Than X Months – 1

  5. Group the three criteria rows:
    1. Click the arrow next to each criteria row, and then click Select Row.
    2. With all three rows selected, click Group AND.
  6. Click Next.
  7. In the Name text box, type a name for the bulk deletion job.
  8. Select a date and time for the job start time; preferably a time when users are not in Microsoft Dynamics CRM Online.
  9. Select the Run this job after every check box, and then in the days list, select the frequency you want the job to run.
  10. If you want a notification e-mail sent, select the Send an e-mail to me (email@domain.com) when this job is finished check box.
  11. Click Next, review the bulk deletion job, and then click Submit to create the recurring job.

Method 9: Delete bulk deletion job instances using a bulk deletion job

When you are bulk deleting data, such as in many of the methods described in this article, a bulk deletion system job is created and can be deleted.

Caution

After you delete these jobs, you will lose the history of the prior bulk deletion jobs that you’ve run.

  1. Click Settings, click Data Management, click Bulk Record Deletion, and then in the menu bar, click New. This opens the Bulk Deletion Wizard.
  2. Click Next.
  3. In the Look for list, select System Job.
  4. In the search criteria area, add criteria similar to the following:

    System Job TypeEqualsBulk Delete

    Status ReasonEqualsSucceeded

    Completed OnOlder Than X Months – 1

    Note

    You could also delete jobs that have failed or been canceled.

  5. Group the three criteria rows:
    1. Click the arrow next to each criteria row, and then click Select Row.
    2. With all three rows selected, click Group AND.
  6. Click Next.
  7. In the Name text box, type a name for the bulk deletion job.
  8. Select a date and time for the job start time; preferably a time when users are not in Microsoft Dynamics CRM Online.
  9. Select the Run this job after every check box, and then in the days list, select the frequency you want the job to run.
  10. If you want a notification e-mail sent, select the Send an e-mail to me (email@domain.com) when this job is finished check box.
  11. Click Next, review the bulk deletion job, and then click Submit to create the recurring job.

Method 10: Delete audit logs

When you enable auditing, Microsoft Dynamics CRM Online creates audit logs to store the audit history of the records. You can delete these audit logs to free space when they are no longer needed.

Caution

When you delete an audit log, you can no longer view the audit history for the period covered by that audit log.

  1. In the Navigation Pane, click Settings. Then under System, click Auditing.
  2. In the Audit area, click Audit Log Management.
  3. Select the oldest audit log. Then, on the Actions toolbar, click Delete Logs.
  4. In the confirmation message, click OK.

Note

You can only delete the oldest audit log in the system. To delete more than one audit log, repeat deleting the oldest available audit log until you have deleted enough logs.

Applies To:

Microsoft Dynamics CRM Online December 2012 Service Update

(For Microsoft Dynamics CRM 2013 topics, view the new Customer Center.)