How to get session timings for logged in users in the instance?

[User477307]

How to get user session timings that is for how long has user logged into the instance? any table which captures such information.

Thanks

[Kalyani Jangam1]

v_user_session table in servicenow to keep all session data of user
Access the table=> go to the Logged in User in User administration and open the record

[Community Alums]

Hi,

'v_user_session' table stores active user sessions.

You can create a scheduled job or business rule on the 'v_user_session' table to check if some of these users has a record for an active session or not. If not - do emit your event and send your notification. Please note that session duration is user defined. If it is for example 24 hours, there will be a record for the logged in user for 24 after they have been active.

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[User477307]

This for current logged in user. I need data for previous session data of previously logged in users as well any table for that?

[Community Alums]

Hi,

You have edited your question, as when you asked this question you asked for "current logged in users". don't change questions, better to raise another question.