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

[salvadormarchan]

All,

Is there a table inwhich a user has logged in? Or, how would I know that a user has logged in?

I need to report on the users who have not use ServiceNow for the last 60 days.

Thanks in advance.

Dor

[marcguy]

last login time is a field on the sys_user table.

Marc

[mslater]

You can run a list report on the Sys User table. Make sure you add the field for Last Login Time.

Add Filter condition similiar to:   Last Login Time before Last 6 months

This will not include any time where they have never logged in.  

To add those you can add: Or Last login time is empty

[Anurag Tripathi]

Hi Salvador,

there is an OOB field on the sys_user table called Last Login Time, it holds the date time when the user last logged in.

[rgm276]

sometimes a picture is worth a 1000 words