How to check the last login date/time of each contact.

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

The Technical Reference Guide says that the "WEB_LAST_LOGIN" field on the USP_Preferences table as "Indicates the time of the last web login.". However, this field is set NULL.

How may we check the last login date time of each contact?

Solution:

The "WEB_LAST_LOGIN" field is not used in the current releases.

However, you can query the session_log table to get that information.
Below is an example using Microsoft SQL:

Select dateadd(ss,MAX(s.login_time)+32400,'1/1/1970') as Last_Login_Date_Time,
s.contact, c.last_name, c.first_name,
c.userid
FROM session_log s
INNER JOIN ca_contact c
ON
s.contact = c.contact_uuid
GROUP BY s.contact, c.last_name, c.first_name,
c.userid

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: