Exporting all assignment groups and associated members

Go to solution
fowlemr
Tera Contributor

‎02-20-2024 08:51 AM

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!

Labels:
0 Helpfuls
  • 1,033 Views
1 ACCEPTED SOLUTION

Go to solution
Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-20-2024 09:02 AM

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

Go to solution
Dr Atul G- LNG
Tera Patron
Tera Patron

‎02-20-2024 09:02 AM

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]

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

Go to solution
fowlemr
Tera Contributor
In response to Dr Atul G- LNG

‎02-20-2024 10:02 AM

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

Go to solution
Sumanth16
Kilo Patron

‎02-20-2024 09:48 AM

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