Does anyone have a report that would show a count of users that has accessed ServiceNow with itil role

pagdenl
Giga Expert

I am looking for a report that would give me a list of user who are using the system.  I have tried the usage report but it stops at 50 users no matter the conditions I use.  Anyone have a idea why it stops at 50.  Global report name "Usage of ServiceNow Applications".  

Or if there is a different report I can collect data of how many user with the itil role access the system that would be great as will.

 

7 REPLIES 7

Shane J
Tera Guru

Setup your report like this and you should be good to go.

 

find_real_file.png

Allen Andreas
Administrator
Administrator

User Administration > Roles, select ITIL, look at the users Tab. For a list anyway, otherwise query User Role table in your report.


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Shiraz2
Mega Guru

Please see attached. This is an update set that will create a report for you. Import it and then commit it. Make sure you do this in Non-Prod Environments first.

 

This will:

ITIL User Activity Report is a great way to gain an on-demand view of who your itil-roled users are and how active they are in your ServiceNow instance:

-Adds an 'ITIL User Activity' application in the left nav.
-Choose the 'Run Report' option to generate a report showing the last login time and last task-based activity for each itil-roled user.
-Use this information to assess user activity and find inactive users who may be unnecessarily consuming your ServiceNow licenses.

Note:
-The 'itil.user.activity.tables' system property contains the list of tables where inserts/updates denotes 'itil activity'. Add or remove tables to meet your needs.

 

Hello, I have imported your update set and have ran the report. However I am only getting 29 users showing up in the report out of 388 ITIL users. This report is exactly what we need however I am not sure what is happening to cause only 29 users in the report. Thanks!