MFP data output from DB Query in Risk Authentication

Products

• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)
• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

Issue/Introduction

We would need to extract MFP data from any given Device ID or User ID.

Environment

Release:ALL
Component: Risk Authentication

Resolution

[A] Query to get device signatures associated to a user 

select devicesignature from arrfdeviceinfo where deviceidseqid in (select deviceidseqid from arrfdevuserasso where username='<username in capital letter>'); 

For example: 
select devicesignature from arrfdeviceinfo where deviceidseqid in (select deviceidseqid from arrfdevuserasso where username='TEST'); 

[B] Query to get device signatures associated to a device id 

select devicesignature from arrfdeviceinfo where deviceid='device id'; 

For example: 
select devicesignature from arrfdeviceinfo where deviceid='r5phe+9SpnI13Zgg2idMeeYrpdlrYEYtoFjA67zBk/IlXxhwbdrkzA==';