Clean up audited tasks from archive

Products

• CA Identity Manager

Issue/Introduction

We would like to clean the archive by deleting only the tasks in the audited state.

We know that with the archive_gcTaskPersistence procedure, we could clean all tasks in the archive before a given date. However, we are only interested in deleting the audited tasks.

Is it possible to create a version of archive_gcTaskPersistence that only deletes audited tasks? Perhaps by adding AND archive_tasksession12_5.state = 16384 to the select statement in this procedure?

Environment

Release : 14.4.2
Component : CA Identity Manager

Resolution

Yes, it is possible to create a copy of the archive_gcTaskPersistence stored procedure and add a state condition to delete all the audit records.

Additional Information

Kindly note that we created a product enhancement request to have a new IM UI task for cleaning the Archive DB.

https://community.broadcom.com/idea/cleanup-submitted-task-archive-db