DB space issue

Document ID : KB000097176
Last Modified Date : 18/05/2018
Show Technical Document Details
Question:
Need to know how to purge archived submitted tasks.
Preferably from within IDM.
If not possible from within, need to be shown where and what to remove on the IDM DB.
Environment:
CA Identity Managaer  R14sp1
Answer:
You would run the following SQL command on the the database that you are storing the Archive Data

USE [IDM_ObjectStore] 
GO 

DECLARE @return_value int 

EXEC @return_value = [dbo].[archive_garbageCollectTaskPersistence] 
@ime_id = N'1', 
@cutoff_time = N'2018-01-16', 
@audit_timeout_days = 1 

SELECT 'Return Value' = @return_value 

GO