UBP data cleanup in Risk Authentication
search cancel

UBP data cleanup in Risk Authentication

book

Article ID: 256795

calendar_today

Updated On:

Products

CA Risk Authentication CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort) CA Advanced Authentication

Issue/Introduction

Is it possible to clean up UBP data because the database has a large amount of outdated data (eg for users/devices that no longer exist)?

Environment

Symantec Risk Authentication 9.1.x

Resolution

Below is the query to cleanup the UBP data for the users who are deleted from the system.

DELETE FROM XUBPDATA where (USERNAME,ORGNAME) IN (SELECT USERID,ORGNAME from ARUDSUSER_ARCHIVE);

The DBA should be involved if the ARUDSUSER_ARCHIVE table has large data (approximately 1M) to add the necessary indexes.

Customer with only a few records (approximately 1k or 2k) does not need an index.