Fetch the users browser and its version information within CA adv authentication.

Document ID : KB000012967
Last Modified Date : 14/02/2018
Show Technical Document Details

Is it possible to fetch the users browser and its version information? I am aware that ARRFDEVICEINFO table in acrotdb has the browser/version info, device id, etc. but there is no username or user id in this table to relate, thus how can I link (device id info) to a (customer/user id)?



Yes, it is possible to fetch above requested information. Using the table ARRFDEVUSERASSO you can map the device information to the users.

ARRFDEVUSERASSO & ARRFDEVICEINFO tables within arcot db, both have common column called DEVICEDIDSEQID, using which you can fetch this information.

With the help of your database admin, you will have to write a sql query to return all users with their browser and version information.