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

Article Id: 20033

Status: Published

Updated On: 14-02-2018 07:51

Legacy Id: TEC597291

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: