MFP data output from DB Query

Products

• CA Rapid App Security
• CA Advanced Authentication
• CA API Gateway

Issue/Introduction

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

Environment

Release:
Component: RSKFRT

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