How to get a list of all users in all groups

Thereza Van der · ‎09-11-2023

Hi everyone 🙂

Please tell me what the quickest way is to get a list of all users in all groups.

Thanks Thereza

Tony Chatfield1 · ‎09-11-2023

Hi, I would extract or report from table Group Members aka 'sys_user_grmember'.

/sys_user_grmember_list.do?sysparm_query=&sysparm_view=

Dr Atul G- LNG · ‎09-12-2023

HI @Thereza Van der

Greetings!!

The table is sys_user_grmember. You can create report in same or access via list view.

https://InstanceName.service-now.com/now/nav/ui/classic/params/target/sys_user_grmember_list.do%3Fsysparm_query%3D%26sysparm_view%3D

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

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

Ankur Bawiskar · ‎09-12-2023

@Thereza Van der

what's your business requirement here?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Thereza Van der · ‎09-12-2023

Okay he wants a list of all people who handles incidents and requests so that he can compile an email group to send them communication if and when needed.

So I thought if I can get a list of all people in groups, I will have a list of everyone who has something to do with an incident/request.