Specific reports for Risk Analysis

book

Article ID: 101571

calendar_today

Updated On:

Products

CA Rapid App Security CA Advanced Authentication CA API Gateway

Issue/Introduction



Share the DB query for below condition so that we can extract from backend DB directly.
- Total count of Unique customer login and device got associated.
- Total count of events triggered specific rule (group by triggered rule).

Environment

Release:
Component: RSKFRT

Resolution

All the historical Risk Authentication transaction related data are stored in ARRFSYSAUDITLOG. 

- Total count of Unique customer login and device got associated. 
select DISTINCT username from ARRFSYSAUDITLOG; 
select DISTINCT deviceidout from ARRFSYSAUDITLOG; 

- Total count of events triggered specific rule (group by triggered rule). 
select count(*) from ARRFSYSAUDITLOG where MATCHEDRULE = 'YOUR_RULE_NAME';