Steps to delete old data manually from Advanced Authentication archive tables and enable db trimming.

Products

• CA Risk Authentication
• CA Strong Authentication
• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)
• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

Issue/Introduction

Steps to delete the old data manually from Advanced Authentication archive tables and enable auto DB trimming.

Environment

Symantec Advanced Authentication 9.1.x

Resolution

Follow these steps to delete the data manually from all archive tables and enable auto DB trimming:

• From product, we recommend the following queries that can be used to identify the record counts and cleanup the records from ARRFSYSAUDITLOG_AR: 

SELECT COUNT(*) FROM ARRFSYSAUDITLOG_AR where DATELOGGED between to_date('01/01/2023'||' 00:00:00', 'mm/dd/yyyy hh24:mi:ss') AND to_date('09/07/2024'||' 23:59:59', 'mm/dd/yyyy hh24:mi:ss');

DELETE FROM ARRFSYSAUDITLOG_AR where DATELOGGED between to_date('01/01/2023'||' 00:00:00', 'mm/dd/yyyy hh24:mi:ss') AND to_date('10/07/2024'||' 23:59:59', 'mm/dd/yyyy hh24:mi:ss');

• Use below table and corresponding column names to manually clean up entries from archive table using above db queries.

Table_Name	Column_Name
ARRFSYSAUDITLOG_AR	DATELOGGED
ARRFSYSAUDITLOG_3DSECURE_AR	DATELOGGED
ARRFSYSAUDITLOG_MOBILE_AR	DATELOGGED
ARRFCASEAUDITLOG_AR	DTCREATED
ARRFINSTANCEAUDITLOG_AR	OPERATIONTIME
ARRFUPLOADAUDITLOG_AR	UPLOADDATETIME
ARADMINAUDITTRAIL_AR	TIMESTAMP
ARWFADMINAUDITLOG_AR	DATECREATED
ARUDSUSERAUDITLOG_AR	TXTIMESTAMP
ARUDSORGANIZATIONAUDITLOG_AR	TXTIMESTAMP
ARUDSCONFIGAUDITLOG_AR	TXTIMESTAMP
ARWFSVRMGMTAUDITLOG_AR	DATECREATED
ARWFISSUANCEAUDITLOG_AR	DATECREATED
ARWFAUTHAUDITLOG_AR	DATECREATED
ARWFGENERICCRED_AR	DATECREATED
ARWFVERIFIEDCHALLENGES_AR	VALIDITYSTARTDATE

• Enable Enabled_Audit_Trim and Enabled_Archive_Trim jobs in dbtrim.properties file based on the organization's data retention policy.

Additional Information

For more information, please refer the section Database Trimming in the product documentation.