Identify the device(mobile or browser) using which user will login into HR portal and store that value in user table

[phanendra varma]

Hi Expects,

I want to create a Report based on which devices users are using when they connect to the service portal.

Mostly if I can store a device name of user he is connecting from in user table when user login's to ServiceNow

I have some data in sys_user_presence table and also in syslog_transaction Table where the data is stored in user agent field in those two tables.

But when even user log in to servicenow the user table should automatically updated on some field with device type from which he is connecting(browser(Internet Explorer, Firefox, Chrome etc..) or mobile(IOS or android), can this be possible ?

If yes can you please provided me the steps to do so?

Thanks in advance. 

[Community Alums]

Hi @phanendra varma ,

There is no table in specific which keeps the login information of all the now-mobile logins or browser logins. But there is a table called "sys_push_notif_app_install"(when a device is able to receive push notifications, there would be an entry here) which our customers are using to tract agent login. Every time an agent logs into the now app, the active would be set to true(And push application will be set to ServiceNow Request Application) and it will give additional information about the device here. Last registered would be the time the agent logs in. This should help you track down the agent login information.

https://<instance-name>.service-now.com/sys_push_notif_app_install_list.do?sysparm_query=sys_push_application_id.display_name%3DServiceNow%20Request%20Application&sysparm_view=

Seen in URL

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep