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

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?

CA Service Desk Manager 12.9CA Service Desk Manager 14.1CA Service Desk Manager 17.0

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

selectca_contact.userid,session_log.* (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:


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: