Any way to tell how long users are staying connected to ServiceNow?

epuchals
Kilo Contributor

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...

1 REPLY 1

sergiu_panaite
ServiceNow Employee
ServiceNow Employee

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