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 · 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

[SN241]

Can someone help me,
I'm having trouble visualizing the cumulative count of users in my ServiceNow reports. The graph shows the same number of users created each month for the last twelve months. I'd like the graph to display a running total, where the user count for each month includes the users from the previous month. For example, if there were 400 users created in January 2024 and 3 users created in February 2024, the February data point should show 403 users.

[Kavita_Bhojane]

Hi @SN241,

Please refer below screenshots:

Also this can be possible with Performance Analytics.

Please mark my answer helpful and accept as a solution if it helped 👍✔️

Thanks,
Kavita Bhojane

[SN241]

hi @Kavita_Bhojane ,
I created a trend report, but the 'Others' category has a very high count, which is causing the data to be inaccurate. I've attached a screenshot of my report configuration. Can you please help me troubleshoot this issue? Thank you.