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

[SumanthDosapati]

@Suggy 

from where is this 'Role Type' field coming from? 

This is not present in OOB Roles table.

[Suggy]

@SumanthDosapati That screenshot is from subscription management dashboard provided by ServiceNow

[Suggy]

@Abhijit4 @SumanthDosapati by the way, how is it possible to merge two reports and create DB view?

From report creating DB view is possible 😮 ?

[Abhijit4]

@Suggy It's not possible to create DB view directly via report. DB view needs to be created separately and you can add above mentioned filter to have only required data. 

Regarding your first question, if you would like to consider all fulfiller type roles then you can plan to add that filter too. This is possible with both either with DB view or script.