SDM: List the Users that have Logged into the Service Desk Web Interface
search cancel

SDM: List the Users that have Logged into the Service Desk Web Interface

book

Article ID: 379210

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager

Issue/Introduction

This article provides a sample SQL Query that can be used to provide a list of the users that have logged into the SDM Web interface.

Environment

Component : SERVICE DESK MANAGER

Release : 17.*

Resolution

use mdb

select [ca_contact].[userid], dateadd(S, [session_log].[login_time], '1970-01-01' ) as 'login', dateadd(S, [session_log].[logout_time], '1970-01-01' ) as 'logoff'
FROM [mdb].[dbo].[session_log]
INNER JOIN [ca_contact] ON [session_log].[contact]=[ca_contact].[contact_uuid] 
order by login

Additional Information

The above query would be executed direct on the SQL Server MDB database via SQL Server Management Studio.

Be cautious when running any queries direct to the MDB database.  Improper execution may cause a lockout of the database for the Service Desk application.