Find people that have a fulfiller licence, but are not part of any assignment group

[Sheetal18]

How to achieve below report-

Find people that have a fulfiller licence, but are not part of as assignment group to see if they are still need this role

Display type	List
Filters	Group is empty Role is assigned to the fulfiller licence User is active
Sorting of the list	Group by Role Name of the user
Fields wanted	Name of the user User ID Email address of user

[mattystern]

I think all of this info should live on sys_user_has_role (typing sys_user_has_role.list in the filter navigator) For roles which are not from a group, you should be able to use a "Inherited != true" filter. For the other filters, a user reference is present, so you would be able to dot-walk / map user ID & email using the list layout.

Hope this helps!

-Matt

[LearnUseThrive]

I've done it when I was building out our Subscription Management. What you want to search for is users who have role and Inherited is false. Inheritance can come from either a group or a parent role. Best Practice is to issue all roles by Group only, so that way it is much easier to track how many Fulfiller licenses are being spent in Subscription Management. It's important, because at contract renewal ServiceNow will want to settle up on the extra licenses being used.

Navigate to User Administration > User Roles.

Set filter criteria to Role = (role) && Inherited = false.

Please also check out this outstanding video on the steps to configure Subscription Management: https://www.youtube.com/watch?v=QUxeEKQEksc

If I helped, kindly mark me correct!