Report - unique users logged in within a month

SC17 · ‎03-02-2022

Hi. Is there a way to create a report to track how many unique users logged in within a month?

Thank you.

Fernando Koenra · ‎03-03-2022

Hi SC,

Performance analytics would be a similar approach compared to the Metric definition.
I've not used PA in a while but I think you could set up a data collection job to track/collect the historic values of the Last Login value of the sys_user records. Preferably only once per week/month and not daily to reduce the dataset.

Similar to metric instances you could then set up indicators and create reports on this data.

As far as I know the login information is also available in the transaction log and event log (an event is generated when the user logs in) but as mentioned it's not recommend to report on these tables (not recommended for PA collection jobs either).

If your end goal is to eventually get more information on how your users use ServiceNow and especially the Service Portal and such - you may also want to look into User Experience Analytics 🙂

Kind regards,

Fernando

View solution in original post

Muhammad Khan · ‎03-03-2022

Yes, this will definitely affect the performance.

Monika13 · ‎03-03-2022

Hi,

Create a report with below condition

SC17 · ‎03-03-2022

Hi. But, if I use Last Login, lets say, we are in May, and I want to know how many users logged in in January. If I am using the Last Login field, if a user last logged in in May, it wont show up in January.

Monika13 · ‎03-03-2022

Hi,

will this help? you have select months every time

SC17 · ‎03-03-2022

Hello. The Last Login field changes everytime a use logs in. I want a report that can show me the number of unique users that were active within a certain month. If I login today, the Last Login gets updated to today, so my user won't show up in a report of active users in January.

EDIT: Something like this