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.

[Ankur Bawiskar]

@Staxed 

you will require database view for this and join sys_user, sys_user_has_role, sys_user_grmember table

[Hemanth M1]

Hi @Staxed ,

Create database view as below :

and report with this condition and group by group:

Mark correct if it helps.

Thank you,

Hemanth

[gatotaco]

Do not use this. This database view and report will not generate the desired results. Since the where clause is based off of the user, if a user has multiple groups with different roles it will generate an inaccurate report adding the sum of these group's roles.

[Eddie5]

Hi Everyone,

You can join two tables as below screenshot and create a Database view to report on Users who have ITIL role along with their respective assignment groups that they are part of.

Mark This as Helpful if this answers your query.