Any way to tell how long users are staying connected to ServiceNow?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-17-2015 06:15 PM
I'd like to run a report showing average login time for users. I'd settle for a detailed list of logins showing login and logoff time and date. Then I could calculate the duration of the session. I've looked all over the system and I've only found half the equation: The Last Login Time is stored for each user. But I haven't been able to find a logoff time anywhere.
Anyone have any ideas?
Thanks,
Eric...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-18-2015 12:32 AM
Hi Eric,
I think that might be a bit difficult. You need to take into account that there are users that never logout, but their session is destroyed if inactive for session timeout period:
Modifying Session Timeout - ServiceNow Wiki
When a user logs in, he/she gets a unique session id. This session id is removed when session gets destroyed (either via logout or session timeout).
In Client Transactions log (System Logs -> Client Transactions) we store this session id as well in "Session" field, as well as user id in "Created by" field. You can probably make a report and see when first transaction with a particular session id was inserted into this table and when last one was inserted. This would give you an approximate time of activity for a user in the instance. If that user logs out and then logs back in, he/she would have a new session id.
Hope this helps.
Regards,
Sergiu