Exporting all assignment groups and associated members

[fowlemr]

Hi everyone.

Looking for a way to export (to Excel) all assignment groups with their associated members.  Several new CAB members are unsure who to assign a CR to without having to go into each assignment group separately...need a reference guide.

Thanks!

[Dr Atul G- LNG · Accepted solution]

Hi @fowlemr 

Create a report  on Group membership

[fowlemr]

Thank you!  Had trouble finding the right table, but your screenshots helped!

[Sumanth16]

Hi @fowlemr ,

You can create a report on the table 'sys_user_grmember'. And add condition Group = <your group name>

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda