Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Application for showing Empty Groups

EthanJacocks
Tera Contributor

Hi all, I am trying to create an application module that can show the customer a list of empty groups. Right now it is set up so that the module is on the sys_user_group table and that is working properly, but I am struggling to have it only show the empty ones. Current strategy is to use a before query business rule on the view that I set through the module (so that it only triggers when using this module) but I'm not sure how to only query for empty groups. I know I need to utilize the sys_user_grmember table in some way but past that I'm lost. Thank you for any input!

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @EthanJacocks 

 

did you try the link type

 

AGLearnNGrow_0-1711472592209.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]

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