How to remove the group member from assignment group automatically

[BalaLalitha Gun]

Hi,

I have created one assignment group "ABC". There were another 3 assignment groups in which if some of the user has been added in those 3 groups then automatically the user will be added in to the "ABC" group.

But now, if any user has been removed from the 3 groups then i have to check if that particular user has been removed from all the 3 groups then automatically it should be removed from the "ABC" group.

Kindly help me to achieve this request.

Thanks,

[Basheer]

Hi @BalaLalitha Gun ,

You can write a business rule on sys_user_grmember table with delete operation.

In the code

var userRemoved = current.user;
var checkUser = new GlideRecrod("sys_user_grmember");

checkUser.addQuery("user",user);

checkUser.addEncodedQuery("write the query stating in one of 3 groups )

checkUser.query();

if(checkUser.hasnext()){

return false;

}

else{

var deleteUserMember = new GlideRecrod("sys_user_grmember");

deleteUserMember .addQuery("user",user);

deleteUserMember.addQuery("group","ABC");

deleteUserMember.query();

if(deleteUserMember.next()){

deleteUserMember.deleteRecord();

}

}

[jaheerhattiwale]

@BalaLalitha Gun Create a before delete business rule on "sys_user_grmember" table

Add below script:

var grpMember = new GlideRecord("sys_user_grmember");

grpMember.addQuery("user="+current.user.toString());

grpMember.addQuery("groupIN<COMMA SEPARTED ALL # GROUP SYS IDS>");

grpMember.query();

if(!grpMember.next()){

var grpMember1 = new GlideRecord("sys_user_grmember");

grpMember1.addQuery("user="+current.user.toString());

grpMember1.addQuery("group=<ABC GROUP SYS ID>");

grpMember1.deleteMultiple();

}

Please mark as correct answer if this solves your issue.