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-02-2022

Hi SC,

You can generate report on the field Last Login of sys_user.

Hopefully this will help you.

Regards,

Muhammad Khan

SC17 · ‎03-02-2022

Hello. But the last login will give me the last time the user logged in. I want to report on unique users in a month, how many unique users logged in for example in February.

Muhammad Khan · ‎03-02-2022

Well, then you might need to apply filter on URL (contains /login.do?sys_action=sysverb_login&user_name=) and Created field of syslog_transaction table, and group by Created By field as follows;

Another approach would be reporting on sysevent table because there is a OOB event known as login.

But to be honest I have never generated reports using these two approaches.

Hopefully this will give you a direction.

SC17 · ‎03-03-2022

Hello. OOB there is no option to report on syslog table because of performance issues.