Specific reports for Risk Analysis

Document ID : KB000101571
Last Modified Date : 14/06/2018
Show Technical Document Details
Question:
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).
Answer:
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';