Project and Portfolio Management Practitioners Forum
cancel

USER Last Login Date

Highlighted
PCross
Contributor.

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
Acclaimed Contributor.

Re: USER Last Login Date

See attach. Table KNTA_LOGON_ATTEMPTS--Creation_date
PCross
Contributor.

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
Acclaimed Contributor.

Re: USER Last Login Date

try query from attach. It work fine
PCross
Contributor.

Re: USER Last Login Date

Will do.

Thanks for your help.