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

Component: Symantec Advanced Authentication
Release: 9.1.xx (Applicable to all the supported releases)

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

• Sample script for Microsoft SQL Server database, ArchiveTrim.sql, is attached for reference.
• 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.