Send a notification when a group is empty

[Jesus Nava]

Hello experts, there is a group called "testers" users can add themelves or remove themselves from that group. When the group has no members or gets empty, a notification needs to be sent to the managers notifying that the "testers" group is empty.

I tried the followimg:

1.Created a notification using the sys_user_grmember table and triggered by event.

2. This is the event that will trigger the notification:

3. Created Business rule that will trigger the event so that the notification is sent, here is the condition:

and here is the advanced script:

when I tested it, I removed all users from the group but the notification was not sent, where am I wrong? could you help me correct it? 

Thank you

[AnveshKumar M · Accepted solution]

Hi @Jesus Nava,

In the business rule, when to run, remove the condition User is Empty and change the trigger to Delete instead of Update.

Then in the script, add the following code,

var gr = new GlideRecord('sys_user_grmember');

gr.addQuery('group', current.group);

gr.query();

if(!gr.next()){

    gs.eventQueue('test.group.empty');

}

Try this.

Thanks,

Anvesh

[Jesus Nava]

Thank you Elijah!