Exporting all assignment groups and associated members

fowlemr · ‎02-20-2024

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 · ‎02-20-2024

Hi @fowlemr

Create a report on Group membership

*************************************************************************************************************
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

Dr Atul G- LNG · ‎02-20-2024

Hi @fowlemr

Create a report on Group membership

*************************************************************************************************************
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]

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

fowlemr · ‎02-20-2024

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

Sumanth16 · ‎02-20-2024

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