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 to get all the DeviceID and Machine Finger Print of a user from Advanced Authentication database?

Environment

All Risk Authentication Environment

DB: Oracle

Resolution

You can 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