Tables involved in the "Audit Trim" operation in AA 9.0

book

Article ID: 194139

calendar_today

Updated On:

Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort) CA Strong Authentication CA Rapid App Security CA Risk Authentication CA Advanced Authentication

Issue/Introduction

Hello,
we would like to kindly know which tables are involved in the "Audit Trim" operation
( https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/advanced-authentication/9-0/administrating/database-trimming.html ).

In the documentation only the "Archive Tables" ( "_AR" tables, involved in the Archive Trim task ) are described.


Thanks

Environment

Release : 9.0

Component : AuthMinder(Arcot WebFort)

Resolution

If you put the arcotuds.log in DEBUG mode, you will see the list of tables getting printed and how much data is archived from those but here is the list -

Table ARUDSUSERAUDITLOG 
Table ARUDSORGANIZATIONAUDITLO
Table ARWFSVRMGMTAUDITLOG
Table ARRFCASEAUDITLOG
Table ARWFAUTHAUDITLOG
Table ARRFSYSAUDITLOG
Table ARUDSCONFIGAUDITLOG
Table ARWFADMINAUDITLOG
Table ARRFUPLOADAUDITLOG
Table ARWFVERIFIEDCHALLENGES
Table ARWFISSUANCEAUDITLOG
Table ARWFGENERICCRED
Table ARRFSYSAUDITLOG_3DSECURE
Table ARRFINSTANCEAUDITLOG
Table ARRFSYSAUDITLOG_MOBILE