What tables are pruned by DBprune tool as a default in Advanced Authentication?

Products

• CA Advanced Authentication
• CA Risk Authentication
• CA Strong Authentication

Issue/Introduction

At 8.1.x a DB trimming capability to automatically prune a list of tables was introduced. Note that a DBprune tool also exists that can be run manually from the command prompt. The DBprue tool is an alternative to the automatic DB trimming capability. This document answers a specific question about the list of tables that are trimmed by default by these two - DB trimming capability and DBprune tool.  

Please refer to the following link to learn more about the DBprune tool. 

https://docops.ca.com/ca-advanced-authentication/9-0/en/administrating/administrating-ca-strong-authentication/system-administrators-utilities/remove-outdated-audit-logs-with-the-dbprune-tool

What tables are pruned  by DBprune tool as a default ?

Environment

Any (Development / Staging / Production)

Release : 8.x

Resolution

Note: This information is only applicable for 8.x version of the product and not applicable to 9.1.x version which is the latest and supported versions.

Here is a list of tables that DBprune tool acts on as a default. 

ARADMINAUDITTRAIL 
ARUDSCONFIGAUDITLOG 
ARUDSORGANIZATIONAUDITLOG 
ARUDSUSERAUDITLOG 
ARWFADMINAUDITLOG 
ARWFAUTHAUDITLOG 
ARWFISSUANCEAUDITLOG 
ARWFSVRMGMTAUDITLOG 
ARDBAUDITLOG 
ARAUTHAUDITLOG 
ARUDSAUDITLOG 
ARADMINAUDITLOG 
ARRFCASEAUDITLOG 
ARRFINSTANCEAUDITLOG 
ARRFSYSAUDITLOG 
ARRFUPLOADAUDITLOG 
ARRFSYSAUDITLOG_3DSECURE 

Additional Information

Please refer to the following link to learn more about the DBprune tool. 

https://docops.ca.com/ca-advanced-authentication/9-0/en/administrating/administrating-ca-strong-authentication/system-administrators-utilities/remove-outdated-audit-logs-with-the-dbprune-tool