User report with group membership

[Dean1]

Hi Everyone,

I'm after some advice on how to configure a report showing users that meet a certain criteria, which also shows which groups they are a member of. The user criteria is all fine, it is just how to include the group memberships which I am unsure of.
I have pasted in an an example below.

Thanks 😊

User ID	Name	Title	Member of
joe.bloggs@outlook.com	Joe Bloggs	XXX - CBR	ITIL Group 1 ITIL Group 2
jane.bloggs@outlook.com	Jane Bloggs	XXX - SYD	ITIL Group 1 ITIL Group 2 ITIL Group 3
bazz.jones@outlook.com	Bazz Jones	XXX - ADL	ITIL Group 1 ITIL Group 3
shaz.smith@outlook.com	Shaz Smith	XXX - BNE	ITIL Group 1 ITIL Group 2 ITIL Group 3 ITIL Group 4

[Mike_R · Accepted solution]

You would need to report on the Group member (sys_user_grmember) table