Specific reports for Risk Analysis

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';