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

USER Last Login Date

Highlighted
PCross
Occasional Advisor

USER Last Login Date

Can anyone tell me where to find the User Last Login Date using SQL?

I have searched using the SQL Runner to bring back a list of all the Table names but am not sure in which one this data would be captured?

Thanks
4 REPLIES
Semenov Alexand
Esteemed Contributor

Re: USER Last Login Date

See attach. Table KNTA_LOGON_ATTEMPTS--Creation_date
PCross
Occasional Advisor

Re: USER Last Login Date

Thanks.

Do you know if this data is used to populate the field in the User section of the workbench?

Under Authentication there is a field called Last Login Date. There is a field name in one of the tables called LAST_LOGIN_DATE

Unfortunately I cannot remember which table I saw it in.

Thanks

Paul
Semenov Alexand
Esteemed Contributor

Re: USER Last Login Date

try query from attach. It work fine
PCross
Occasional Advisor

Re: USER Last Login Date

Will do.

Thanks for your help.
//Add this to "OnDomLoad" event