Add or remove multiple users from the group

Lakshmi56 · ‎07-26-2022

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 · ‎07-26-2022

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

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

View solution in original post

prasannakumard · ‎05-09-2024

@Ankur Bawiskar if I'm trying to add an existing user. is there any script to restrict before adding user into group. Please let me know how can we over come the same.

Thanks & Regards,

Prasanna Kumar

Mohith Devatte · ‎07-26-2022

Hello,

Follow this script to add the members

var usersToBeAdded = current.variables.your_add_members_to_group_variable_name.split(',');

for(var i=0; i<usersToBeAdded.length;i++)

{

var grm = new GlideRecord('sys_user_grmember');

grm.initialize();

grm.group=current.variables.your_group_variable_name;

grm.user=usersToBeAdded[i];

grm.insert();

}

Follow this script to delete members

var usersToBeRemoved = current.variables.your_remove_members_from_group_variable_name.split(',');

for(var j=0; j<usersToBeRemoved.length;j++)

{

var grmd = new GlideRecord('sys_user_grmember');

grmd.addQuery('group',currentvariables.your_group_variable_name);
grmd.addQuery('user',usersToBeRemoved[j]);
grmd.query();
if(grmd.next())
{
grmd.deleteRecord();
}
}

Please let me know if you face any issues

if it works mark my answer correct

Thanks

prasannakumard · ‎05-09-2024

@Mohith Devatte if I'm trying to add an existing user. is there any script to restrict before adding user into group. Please let me know how can we over come the same.

Thanks & Regards,

Prasanna Kumar

Lakshmi56 · ‎07-26-2022

Hi Ankur and Mohith,

Thanks for the response.

Removing users from group is working but users in "Add members to group" are not getting added into the selected group.

Mohith Devatte · ‎07-26-2022

Hello lakshmi ,

can you please share your script for that ?