Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

tiagomacul
Giga Sage

1. Users without any role - Free (who can view ESS portal)

2. Users who are fulfiller (Like working on the change, incident etc) -> Normally they need ITIL role and are charged. - licensed users

 

 

A. SUBSCRIPTION 

 

Subscription Management

Subscrption Types

 

 

 

 

https://<instance>.service-now.com/nav_to.do?uri=/license_details_list.do%3Fsysparm_userpref_module%3D51410040c3322100f4a13b251eba8fbc%26sysparm_clear_stack%3Dtrue

 

 

 

 

>> Subscription Management > Subscriptions

 

tiagomacul_8-1721913787058.png

tiagomacul_10-1721913884324.png

 

tiagomacul_11-1721913912673.png

 

 

Instance Usage 

>> Instance Usage

 

 

 

B. Default report

by Göran Lundqvist

 

Image Description
tiagomacul_0-1721912789134.png

 

01. >> System Security > Reports > Role Allocation
tiagomacul_0-1721913111225.png

 

02. Looking results...
   

 

 

C. Coding

 

 Counting using script By mallen_nspi

 

 

 

 

var user = new GlideRecord('sys_user');
user.addActiveQuery();
user.query();
var count = 0;
while(user.next()){
         var role = new GlideRecord('sys_user_has_role');
         role.addQuery('user', user.sys_id);
         //role.addQuery('role.name', 'itil');
         role.query();
         if(role.hasNext()){
                   count++;
         }
}
gs.print(count);

 

 

 

 

 

 

 

D. Couting

 

Looking for sys_user_has_role

 

 

 

 

https://<instance>.service-now.com/nav_to.do?uri=/sys_user_has_role_list.do

 

 

 

 

01. export 

tiagomacul_1-1721913229271.png

02. Download

tiagomacul_2-1721913278742.png

 

03. let just user column

04. Remove duplicates

 

 

 

E. REPORT

 

New Report (file attached)

 

01. Navigate >>Reports > View / Run

tiagomacul_1-1721913510896.png

 

 

02. Create a report

 

tiagomacul_3-1721913544339.png

 

 

tiagomacul_2-1721913528532.png

 

 03.  type the Report Name

Select Source Type: Table

Table: sys_user_has_role

tiagomacul_4-1721913592829.png

 

 

04. Select Bars

tiagomacul_5-1721913640528.png

 

 

05. Select Group By Role

tiagomacul_6-1721913665265.png

 

 

06. Run

tiagomacul_7-1721913676478.png

 

07. Result

 tiagomacul_0-1721913111225.png

 

 

 

 

 

tiagomacul_0-1721913468291.jpeg

 

Monitoring how subscriptions are allocated

View your subscription applications and allocation levels

Why a subscription might not appear in the list

Allocating users to a Per-User subscription

Monitor how resources are allocated to subscriptions

Monitor subscription compliance

 ITOM Subscription Unit license calculation logic

Configuring Subscription Management with Groups

 

Washington's Time-Limited User Roles

 

 

 

 

 

 

 

Comments
Goran WitchDoc
ServiceNow Employee
ServiceNow Employee

Just a quick comment. No need to create your own report, there is actually already one and even a module point to it called "Role Allocation":
find_real_file.png

//Göran

User674366
Tera Explorer
Thanks for sharing this.
Lexter
Mega Contributor

Hi, 

I found this role = "user"

and I believe this is Out of box.  Does it consume license?

find_real_file.png

tiagomacul
Giga Sage

does it role grant access to some table?

 

IF "Create, delete, and modify any record", Ye, it need license.

 

* The best procedure it's ask fro your AM.

Version history
Last update:
‎11-25-2024 01:48 PM
Updated by: