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

[aarya1]

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 · Accepted solution]

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

[aarya1]

Hi @Ankur Bawiskar 

Thanks for your help

I will try that script

Regards 

Aarya

[Ankur Bawiskar]

@aarya 

Sure. Do keep posted.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

[aarya1]

Hi @Ankur Bawiskar 

Your script helped me a lot and i did changes  as per my requirement .

Now its working

Thanks @Ankur Bawiskar 

Regards

Aarya

[aarya1]

Hi @Ankur Can we add 3 roles to single group by using fix script Regards Aarya