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.9
CA Service Desk Manager 14.1
CA Service Desk Manager 17.0
This information is stored in the session_log table. You can extract the information with a SQL query like:
FULL JOIN ca_contact on session_log.contact=ca_contact.contact_uuid
where (login_time > 1580418371 AND login_time < 1580444127) order by login_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/
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: