MFP data output from DB Query

book

Article ID: 107557

calendar_today

Updated On:

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