how to see how many have logged in servicenow for a period of 6 months

[sunthosh]

I have to see every day how many users are logging in with respective of every minute. for a period of 6 months

[Alikutty A]

Hi Hari,

You can check the events logs with event name as 'login'. The Parm 1 column gives you the user Id who had logged in. This will give you a data for last 30 days (depending on how many days you store these logs)

You can also run query on last login time on user profile

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[harishdasari]

Hi Hari,

Run report on Sys_user table and add filter condition as login last 6 Months.

You will get all users who logged in.

Thanks

[sunthosh]

I do not want last login time.   I need to know how many users are logging at a particular time

i want last 6 months data

Sample of data:

• 05 represents 5 a.m morning
• Next two column represents minutes and seconds respectively
• Last column represents the no of users logged in that particular time.

[Alikutty A]

You can check the events logs with event name as 'login'. The Parm 1 column gives you the user Id who had logged in. This will give you a data for last 30 days (depending on how many days you store these logs).

This is what system provides oob and the data will depend on how long the logs are maintained. If you need something else you should try custom logging on this event.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response.