Report - unique users logged in within a month

[SC17]

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

Thank you.

[Fernando Koenra]

Hi SC!

As was already mentioned it is generally not recommended to report on the transactions, as due to the large amount of data it that is not optimized for reporting - it can affect performance. 

Reporting on the Last Login field of the sys_user would be a better option.
It depends of course on what exactly your reporting requirements are, and how much data you would need. 🙂 Users may also not appreciate it if too much of their specific system usage is being reported on actively. 

If you just want to report on unique users that have logged in during a month you would have to track when a user logs in to be able to report on history.

Otherwise if you want to report on unique users that logged in on the month January- users that have logged in today (March) will not show up anymore.

If you want to track the Last Login time for unique users in a simple way you could define a simple Metric definition on this field on the user table, and report on the metric instances (grouped by time & user).
Maybe even add a condition so that it only generates a metric instance entry per unique month if that matches your requirements.

If you need to track this for a large amount of users in general - it would be recommended to reduce your dataset as much as possible to keep up a good performance. 🙂

Another option could be using Performance Analytics if this is something that you're already using.

Kind regards,
Fernando

[SC17]

Hi Fernando, thank you for the response. With Performance Analytics what would be the best approach? I assume that I would need to interact with the sys log table anyways to track logins and the dates, but I also read somewhere that after 7 days this data gets deleted.

Is there a OOB way to do this with Performance Analytics?

[Fernando Koenra · Accepted solution]

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

[SC17]

Thank you for the replies. I will dig into PA, never worked with PA reporting before, so let's see what I can do. Thank you again.

[Research]

Hi @SC17  Did you got any solution on users report