By using fix script we need add roles to the groups .

aarya1 · ‎03-08-2022

Hi

My requirement is to add one role to particular groups by using fix script.

There are some filter conditions while querying the group table , below are the filter conditions

Group should be active, group should be itil, and group should be non working group.

By using those conditions we need to get that particular groups if those conditions are matched then we need to check that particular groups has sn_role , if this role is there to that groups then dont do any thing , if that role is not there to that groups then add sn_role.

This is my requirement.

Please suggest with your answers.

Thanks in advance

Regards

Aarya

Ankur Bawiskar · ‎03-08-2022

Hi,

something like this; enhance it

addRole();

function addRole(){
	try{
		var gr = new GlideRecord("sys_user_group");
		gr.addEncodedQuery("Your Query"); // give your query here
		gr.query();
		while(gr.next()) {

			var gr1 = new GlideRecord("sys_group_has_role");
			gr1.addQuery("group", gr.getUniqueValue());
			gr1.addQuery("role.name", "sn_role"); // give exact role name here
			gr1.query();
			if (!gr1.hasNext()) {
				gr1.initialize();
				gr1.group = gr.getUniqueValue();
				gr1.setDisplayValue('role','sn_role'); // give exact role name here
				gr1.insert();
			}
		}
	}
	catch(ex){
		gs.info(ex);
	}
}

Regards
Ankur

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

View solution in original post

Ankur Bawiskar · ‎05-24-2022

yes why not

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

aarya1 · ‎05-24-2022

Hi Ankur Pls tell me the logic I have a script to add single role to a single group as u mentioned in above conversation. But i dont have logic to add 3 roles at a time. Pls help me Regards Aarya

Ankur Bawiskar · ‎05-24-2022

Hi,

3 roles at a time but you will have to iterate it one by one

Regards
Ankur

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

aarya1 · ‎05-24-2022

Hi, One by one roles will add right?

aarya1 · ‎05-24-2022

Hi Can u pls send me the logic how to implement it Thanks in advance Regards Aarya