Database Query to get Machine Finger Print and DeviceID of a user in Risk Authentication?

Products

• CA Advanced Authentication
• CA Risk Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)

Issue/Introduction

How do I get all Device ID and Machine Finger Print of a user from database?

Environment

All Risk Authentication Environment

DB: Oracle

Resolution

Please run the below query against the database to get all the DeviceID and Machine Finger Print of a user

select * from ARRFDEVICEINFO where deviceidseqid IN( select deviceidseqid from arrfdevuserasso where username='<USERNAME>' and orgname='<ORGNAME>');

Additional Information

N/A