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

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

You would like to know which tables are involved in the "Audit Trim" operation (Database Trimming).

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

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