Absent Member.. Raka_1 Absent Member..
Absent Member..

Last Login Attempt by any user

Where does the Last Login exists for any user. We have a requirement where we want to find out that when was the last time a user logged in. I know I can find it from the workbench for each user but we want to a whole list of 400-500 users.
3 Replies
Absent Member.. Linda Hauck Absent Member..
Absent Member..

Re: Last Login Attempt by any user

Here is some sql to get all users last login after Dec 31 09:

select u.username, la.creation_date
FROM knta_logon_attempts la, knta_users u,
(SELECT max(knta_logon_attempts.logon_attempt_id) as L_Login,
knta_logon_attempts.username as who, knta_logon_attempts.user_id as who_id
FROM knta_logon_attempts
WHERE knta_logon_attempts.creation_date > '31-DEC-2009'
GROUP BY knta_logon_attempts.username, knta_logon_attempts.user_id) maxlogin
WHERE la.user_id = maxlogin.who_id
and maxlogin.who = la.username
and maxlogin.L_Login = la.logon_attempt_id
and u.user_id = la.user_id
ORDER BY u.username
Vibhor Dwivedi Absent Member.
Absent Member.

Re: Last Login Attempt by any user

SELECT username, count(*)
FROM knta_logon_attempts
WHERE creation_date > sysdate -
GROUP BY username
ORDER BY username

KNTA_LOGON_ATTEMPTS stores all of the attemps to logon to the server,
both successful and failed. If there was a failure, the failure message name is
stored as well.

KNTA_LOGON_ATTEMPTS table contains information about attempts to log
on to the PPM Server over the previous 14 days
B Swanson Absent Member.
Absent Member.

Re: Last Login Attempt by any user

If you just want to know the last time people logged in to the tool, that is on the KNTA_USERS_V database view (along with most of the rest of the user information):

select last_logon_date from knta_users_v
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.