Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Last Login Attempt by any user

Highlighted
Raka_1
Collector

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
Linda Hauck
Regular Collector

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
Regular Collector

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
Regular Collector

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
//Add this to "OnDomLoad" event