logo

NJP

ServiceNow Subscription Usage, License Utilization, Counting Licensed Users.

Import · Jun 30, 2018 · article

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

image

image

image

Instance Usage

>> Instance Usage

image

image

B. Default report

by Göran Lundqvist

Image Description
image 01. >> System Security > Reports > Role Allocation
image 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

image

02. Download

image

03. let just user column

image

04. Remove duplicates

image

E. REPORT

New Report (file attached)

01. Navigate >>Reports > View / Run

image

02. Create a report

image

image

03. type the Report Name

Select Source Type: Table

Table: sys_user_has_role

image

04. Select Bars

image

05. Select Group By Role

image

06. Run

image

07. Result

image

image

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

View original source

https://www.servicenow.com/community/now-platform-articles/servicenow-subscription-usage-license-utilization-counting/ta-p/2321993