Groups without ITIL users

[afrpereira]

How can I know if there is any group without ITIL users? 

[Elijah Aromola]

Are you looking to find groups that have the ITIL role directly or groups that don't contain users with an ITIL role not inherited from that group?

[afrpereira]

I'm looking to find groups that don't contain any user with an ITIL role

[Elijah Aromola]

Can you provide some more details about what you're trying to do? Is this something you need a report for? Just want to check one time? 

[Aman Kumar S]

@afrpereira 

Your requirement will require a scripting solution if you are just looking for output or if you are planning to build a report for this, you will need to create a database view between the Group membership(sys_user_grmember) table and User Role(sys_user_has_role) table, and through that, you will be able to see the association of the users who have the ITIL role access.