How to find list of users who have both Fulfiller and Business stakeholder role types?

Suggy
Giga Sage

As per ServiceNow, if a user has both Fulfiller (FF) and Business stakeholder (BSH) role, ServiceNow will consider that user as under Fulfiller role by default.

 

Problem:

In our instance, there are many users who have both FF and BSH roles. Many of those users were supposed to have just BSH only but somehow got FF role as well.

Now we need to clean them up.

Question - How do we create a report to find all those users who have both FF and BSH role types?

 

PS - We have few groups where the group role contains sn_incident_write. Once a user is added to this group, the user would also get sn_incident_read as part of inheritance.

On other hand, we have group with role sn_incident_read.

Now when I created a report, above user falls under both FF and BSH reports due to license inheritance.

So we are not able to create a report at all to find out the list of users having both those roles.

 

How are you tracking this scenario?

Note - FF role means list of all licensable roles

Suggy_0-1746540399233.png

 

 

8 REPLIES 8

GlideFather
Tera Patron

Navigate to the User roles table:
https://YOUR-INSTANCE.service-now.com/sys_user_has_role_list.do 

And there you can review what user has what roles, you can also filter or group the results to get what you need.

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


Abhijit4
Mega Sage

Hi @Suggy 

 

I think we need to have database view to find out all users who has both Business Stakeholder and ITIL role.

 

One report: User who has Business Stakeholder Role.

Report Link: https://instancename.service-now.com/sys_user_has_role_list.do?sysparm_query=role.nameLIKEbusiness_s...

 

Second Report: User who has ITIL Role.

Report Link: https://instancename.service-now.com/sys_user_has_role_list.do?sysparm_query=role.name%3Ditil&syspar...

 

Now create database view to merge these two reports based on matching user that will give you all users who have both roles.

 

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

SumanthDosapati
Mega Sage
Mega Sage

@Suggy 

If it's a one time use, then you can run a bg script to print the results of users who has both the roles.

If you wish to keep it as a report then as suggested by @Abhijit4 database view is the option.

 

Regards,

Sumanth

@Abhijit4 @SumanthDosapati its not just itil and business_stakeholder role. 

When I say ITIL, we need to consider all the fulfiller roles

Suggy_0-1746540168301.png

Is it still possible via DB views or scripts?