ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
How to check the last login date/time of each contact.
Article ID: 20033
Updated On:
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:
Component:
Feedback
Yes
No
Powered by
