Report to show users from a specific group that have itil role

[Staxed]

I've been playing with this for a while now and can't find a way to do this.

I would like to create a report that shows all users with the itil role from a specific set of groups.  I've tried sys_user, sys_user_has_role and sys_group_has_role and can't seem to get exactly what I'm looking for.  Is something like this going to require a database view (never done one before).

Any suggestions/advice on how to accomplish this would be awesome.

[Tsura Andreeva]

you can try the related list condition on Roles

[Staxed]

That still leaves the issue of limiting it to only a specific set of groups, which I can't seem to do using the sys_user table.

[Tsura Andreeva · Accepted solution]

Normally ITIL roles come from the groups, perhaps try this:

[Staxed]

aha, a table I hadn't tried yet, sys_user_grmember did the trick, thanks!