Is there a way to determine the last login date of users in Xtraction?

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Question

Is there a way to determine the last login date of users in Xtraction?

Answer

Run the following query against the Xtraction database

SELECT [User].[UserId],
 [User].[Username],
 [User].[FirstName],
 [User].[LastName],
 [User].[EmailAddress],
 [User].[Locale],
 [UserSession].[UserSessionId],
 [UserSession].[LoginTime],
 [UserSession].[LastPing],
 [UserSession].[IPAddress]
FROM [User]
 JOIN [UserSession]
 ON [User].[UserId] = [UserSession].[UserId]
WHERE [User].[Username] = 'ENTER USER NAME HERE'
ORDER BY LoginTime DESC

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: