Need reporting on business stakeholder license consumption (unique license, excluding ITIL)

[Suggy]

We have created reports on sys_user_has_role table to calculate itil and business_stakeholder licencse usage.

Issue is that, few users who have both the above roles., hence such users are getting reported in both reports.

But since ServiceNow's license count is based on the higher privilege role assigned to a user, not on both roles together, if a user has both roles, then only ITIL will be considered for that user right.

Hence in this case, how can report such a way that, of user has both itil and business_stakeholder, eliminate such users from 'Business stakeholder licensed users' report.

[Brian Lancaster]

Why do you have itil user with the business_stakholder role? An itil user can already do everything the is granted by the business_stakeholder role.

[Suggy]

Hi @Brian Lancaster Thats true. There are some workflows and automations which needs to be corrected.

Also there are some scenarios where a user initially has Business_stakeholder role but later requested ITIL, which was granted via flows, this ended up with both roles.

All the corrections are in progress but will take time.

Hence, meanwhile wanted to check if there any way to get this reporting done.

[Brian Lancaster]

I think you will have to do two separate reports on the sys_user_has_role table. 

The filter should look something like this but will have business_stakeholder. I don't use that so I tried with a different role.

Then the second report you will just saw is and is not.

[Suggy]

Hi Brian,

I did not get that. Which 2 reports should I create?

If I just create the first report which you shared, that did not give me the right result.