How to create report on monthly active users (sys_user table) in ServiceNow?

[SN241]

Hi. I'm new in ServiceNow, I'm looking to create a report in ServiceNow that displays the monthly count of active users for the past 12 months. Here's what I want to achieve:

Condition: Count of active users (filter for users where "active" field is true and Company is ABCompany)

Desired Output: A report or visualization showing the number of active users for each month over the past year)

Your help is highly appreciated! Thank you!

[James Chun · Accepted solution]

Hi @SN241,

You will need to use the Performance Analytics capability to capture a snapshot of the user table on a monthly basis.

Then you can create a Performance Analytics widget to show the trend.

There might be an OOB Indicator that you can use instead of creating a new one.

Cheers

[James Chun]

This does not meet the requirement, it's reporting on the number of user records that were created per month.

[AndersBGS · Accepted solution]

Hi @SN241 ,

As @James Chun already mentioned, you need to utilize performance analytics, as there you have no specific date field in your requirement. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[SN241]

Thank you @AndersBGS and @James Chun, is this the creating of Indicators? Thank you.

[James Chun]

@SN241

Correct, there could be an OOB Indicator that you may be able to use.

You also may need to run some data-collecting jobs as well.

[SN241]

I already created the scheduled data collection, but when I executed it, I got an error