CA Rapid App SecurityCA Advanced AuthenticationCA 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';