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

[AndersBGS]

Hi @SN241 ,

Yes, automated indicator together with indicator source and widget for visualization.

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

Best regards

Anders 

[SkyGarden]

There is a oob indicator but we cant edit or modify based on requirement like as put a filter condition Email is not empty they did not allow.

So please help me to create a indicator so that we can get the monthly active user count.

[Maik Skoddow]

As already mentioned before, leveraging Performance Analytics would be a good fit - however, only if the table sys_user is audited. Otherwise, you will not get the numbers from the past that way.

But with another approach, you can get the result you have requested. Use the table ua_app_usage for reporting! In that table, ServiceNow permanently tracks for each user the utilized products. As this table is grouped by year and month (column "Accrual period") you have data to report on. The problem with reporting is, that you can break down to one group level. Using the data from table ua_app_usage you would need another breakdown (group-by) for the users. Therefore, a bar chart is not possible. But you could leverage a multi-pivot report like this:

In the last summary row you can see the active users over the last 10 months.