Exporting all assignment groups and associated members

fowlemr
Tera Contributor

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!

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @fowlemr 

Create a report  on Group membership

AGLearnNGrow_0-1708448559766.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @fowlemr 

Create a report  on Group membership

AGLearnNGrow_0-1708448559766.png

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

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

Sumanth16
Kilo Patron

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