Add or remove multiple users from the group

[Lakshmi56]

Requirement is manager of a particular group should be able to add multiple users to the selected group or remove multiple users from the selected group using catalog item.

when manager submits the request, users in "Add members to group" should be added and

users in "Remove members from group" should be removed from the group.

what should be the script in workflow("run Script").

[Ankur Bawiskar]

Hi,

are you sure those users are not already in that group?

Are you using correct variable name?

share your complete script

regards
Ankur

[Lakshmi56]

Hi Ankur,

yes, the selected users are not part of the group.

used the correct variables.

below image:

submitted the requested with group, Add members to group

Group:

Selected users are getting added.

[Ankur Bawiskar]

Hi,

Now you are saying it's working?

Group:

Selected users are getting added.

Regards
Ankur

[Lakshmi56]

Hi @Ankur Bawiskar 

apologies

Selected users are not getting added.

Add members to group

Carla Sirbaugh, Jade Erlebach

below is the group image:

in Group Members related list, users (Carla Sirbaugh, Jade Erlebach) are not added into the group.

[Ankur Bawiskar · Accepted solution]

Hi,

update as this and test

var usersToAdd = current.variables.add_users; // give correct variable name here
var usersToRemove = current.variables.remove_users;  // give correct variable name here

var group = current.variables.group;  // give correct variable name here

var rec = new GlideRecord('sys_user_grmember');
rec.addQuery("group", group);
rec.addQuery("user", "IN", usersToRemove.toString());
rec.query();
rec.deleteMultiple();

var arr = usersToAdd.toString().split(',');

for(var i=0;i<arr.length;i++){
	var addRec = new GlideRecord('sys_user_grmember');
	addRec.addQuery("user", arr[i]);
	addRec.addQuery("group", group);
	addRec.query();
	if(!addRec.hasNext()){
		addRec.initialize();
		addRec.user = arr[i];
		addRec.group = group;
		addRec.insert();
	}
}

Regards
Ankur