How to get a list of contacts who has logged into Service Desk Manager.

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

I need a list of all contacts which have logged in and out in a given time period, let us say for the last week. How can I achieve this?

Environment:
CA Service Desk Manager 12.9CA Service Desk Manager 14.1CA Service Desk Manager 17.0
Answer:

This information is stored in the session_log table. You can extract the information with a SQL query like:

selectca_contact.userid,session_log.*fromsession_logFULLJOINca_contactonsession_log.contact=ca_contact.contact_uuidwhere (login_time> 1498479472 ANDlogin_time< 1498565872)orderbylogin_time

Since all timestamps are stored in Unix epoch time, you will need to use a converter to get the epoch time you need.
The earliest date is the first time, the end date is the second one.

You can use an online converter like: http://www.unixtimestamp.com/

 

Additional Information:

Note 1: Logins from the web interface will return as a session_type 1, while web services are a session_type of 3

Note 2: If you are not using the session_log table information for reporting on users log in and out of Service Desk; then you can turn off session logging by placing the following parameter in NX.env and recycling service:

@NX_SESSION_LOG_EXCLUDE=ALL