How to check if a user is logging in for the first time in ServiceNow?

[Sagar Manocha]

Hi,

I need to fetch a report in which I need to find out the no. of users who have joined the ServiceNow instance in the past week or month. For that, I need to know when the user has logged in for the first time. 

If anyone has come up with same requirement before and knows the solution, please help. 

[asifnoor]

Hi,

If you want to fetch the report of users who joined ServiceNow in the past week or month, you can do this based on user creation date instead of login time.

User login time is NOT equal to user creation time (joining) in ServiceNow.

You can simply create a report on sys_user table and add the condition of created on last month. here is the screenshot for reference. 

Along with last month, you have various filters which you can use such as this month, last month, last 3 months, this week, last week, etc.

Kindly mark the answer as correct if this answers your question.

[Sagar Manocha]

Can't do that as it will not give appropriate result. If I create 10 users today and only 5 are using the accounts, rest 5 have not used it, then the reports will display incorrect result. 

[asifnoor]

Hi Sagar,

In thast case you basically need users who joined service now and actively using it.

You can add another filter to the existing condition

Created on last month

AND

last login on last month

[Sagar Manocha]

That will also not serve the purpose, because if there is a user whose account was created two months ago, but who logged in for the first time in last month, then in this case, this current filter will give wrong result. That is why I need to find out if there is any other way to know when a user is logging in for the first time in Servicenow.