Hi Diana,
I don't know of a way in the UI, but we use the SQL below against the EPIM database to create a report. Not only does it tell you the last time they logged in, it also contains first login date and number of logins. You will need to modify the date (and it excludes the system login).
I hope this helps!
Brenda
select distinct u.LOGIN as [User] ,u.USER_ID as [User Id], u.FIRST_NAME as [First Name], u.LAST_NAME as [Last name],
u.EMAIL as [E-mail address], u.DESCRIPTION as [Description],
isnull(u.[DEPARTMENT], '') as [Department],isnull(u.[BUSINESS_TITLE], '') as [Title], count(s.USER_ID) as [Number of logins],min(s.LOGIN_DATETIME) as [First login date], max(s.LOGIN_DATETIME) as [Last login date]
from B_USER u
left join B_SESSION s on u.USER_ID = s.USER_ID
where
(LOGIN_DATETIME >= '2020-04-21' or LOGIN_DATETIME is null) and
u.USER_ID not in (1)
group by u.LOGIN, u.USER_ID, u.FIRST_NAME, u.LAST_NAME,u.EMAIL,u.DESCRIPTION, u.SECURITY_CONTEXT_VALUE,u.DEPARTMENT, u.BUSINESS_TITLE
order by u.FIRST_NAME, u.LAST_NAME;
------------------------------
Brenda Maxwell | Director Global Product Management
IDEA | \+1 703 562 4600
------------------------------
Original Message:
Sent: 07-16-2020 15:21
From: Diana Dubon
Subject: User Log History
Hello,
I was wondering if there is a way to view export a log history for users and the last time they logged into the system? Any help is appreciated, thanks!