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

[Suggy]

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

[GlideFather]

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.

[Abhijit4]

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.

[SumanthDosapati]

@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

[Suggy]

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

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

Is it still possible via DB views or scripts?