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 database maintenance.
casm173
We recommend that you archive and purge obsolete Verification Log entries, CACF audit history, and CI audit history as part of database maintenance.
The CACF  reports typically present monthly reports with a yearly summary. The default archive purge time 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 for verification log entries, Incidents, and Change Orders. Using the same value ensures data consistency. You can probably change the 30-day default to something more in keeping with your reporting requirements.
To archive and purge audit data, complete the following actions:
  1. To archive and purge inactive Incidents older than
    nn
    days, use the current incident rule.
    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 verify whether the Change Order is active.
  2. To archive and purge inactive Change Orders older than
    nn
    days, use the current Change Order rule.
    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.
    To archive and purge verification log entries older than
    nn
    days, use this rule. By definition, rogue changes are not associated with Change Orders.
  4. Use the CMDB Audit rule to archive information that is shown in the Change Specification History, Verification Policy History, Managed Change State History, and Managed Attribute History tabs. These tabs are shown 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.