Managing Configuration Items › Configuration Audit and Control Facility (CACF) › How to Archive and Purge Audit Data

Previous Topic: Managing Undiscoverable Attributes

Next Topic: Implement a Change Verification Strategy

How to Archive and Purge Audit Data

We recommend that you archive and purge obsolete Verification Log entries, CACF audit history, and CI audit history as part of your periodic database maintenance.

Important! The CACF CA Business Intelligence reports typically present monthly reports with a yearly summary. The default archive purge time value for the archive purge rules for the log, CACF audit history, and CI audit history tables is 30 days. Use the same value in the archive and purge rules to help ensure data consistency between verification log entries, Incidents, and Change Orders. You can probably change the 30 day default to something more in keeping with your reporting requirements.

Complete the following actions to archive and purge audit data:

  1. Use the current Incident rule to archive and purge inactive Incidents older than nn days.

    CA SDM archives and purges verification log entries only after archiving and purging associated Incidents. If you associate a Change order with an Incident, CA SDM does not check if the Change Order is active.

  2. Use the current Change Order rule to archive and purge inactive Change Orders older than nn days.

    CA SDM archives and purges verification log entries and change specifications only after archiving and purging associated Change Orders. If you associated an Incident with a Change Order, CA SDM does not archive and purge the Change Order.

  3. Use the Rogue Change Verification Log rule for rogue changes that did not create an Incident.

    Use this rule to archive and purge verification log entries older than nn days. By definition, rogue changes are not associated with Change Orders.

  4. Use the CMDB Audit rule to archive information shown in the Change Specification History, Verification Policy History, Managed Change State History, and Managed Attribute History tabs show in the respective Change Specifications, Verification Policy, Managed Change State and Managed Attributes detail forms. CA SDM stores this information in the ci_audit table.