How would I know when was the last time a user has logged in?

shaik_irfan · ‎05-30-2017

Hello Everyone,

I wanted to know the user last login details in sys_user table under list layout i added Last login & Last login time but i cant see those fields on my user table.

Thanks in advance.

Chuck Tomasi · ‎05-30-2017

I took a look at the list in User Administration> Users and find the columns there with dates populated on the Last login time field. Am I missing something? This screenshot was from one of the users with admin role (fred.luddy).

Have you tried impersonating other users to see if this is specific to your account?

View solution in original post

tlindof · ‎05-30-2017

There is a field called Last Login Time on the sys_user table.

Chuck Tomasi · ‎05-30-2017

Hi Shaik,

They are there.

shaik_irfan · ‎05-30-2017

Hello Chuck,

As you can see my screen shot in the question i already added Last Login, Last Login time but unable to view the same on the List view

Chuck Tomasi · ‎05-30-2017

Check the ACLs. It could be one of several things (both related to ACLs.)

Do you have read access?

Do you have report_on access?

Do you have add_to_list access?

Docs: Access control rules

Docs: Contextual security

Security Best Practices - ServiceNow Wiki