how to add specific role to all users with itil role

[Alon Grod]

Hi,

im trying to add to all users with 'itil' role a specific role (template_editor_group) but its not working. what am I doing wrong?

 

 

 

[Ankur Bawiskar]

@Alon Grod 

Did you try running the script for limited users?

[Mohan raj]

Hi @Alon Grod,

Try below code its working for me 

var gr = new GlideRecord('sys_user_has_role');
gr.addEncodedQuery('role!=f581eaad0a0a0bc500fbf9055d015838^ORrole=282bf1fac6112285017366cb5f867469');
//gr.setLimit(5);
gr.query();
while(gr.next()){
    var role = 'f581eaad0a0a0bc500fbf9055d015838';
    var gr1 = new GlideRecord('sys_user_has_role');
    gr1.initialize();
    gr1.user = gr.getValue('user');
    gr1.role = role;
    gr1.insert();
}

If my response helps you to resolve the issue close the question by Accepting solution and hit thumb icon. From Correct answers others will get benefited in future.

Regards,

T Mohan.

[Mohith Devatte · Accepted solution]

Hello @Alon Grod ,

please try with below script 

var gr = new GlideRecord('sys_user_has_role');
gr.addEncodedQuery('role=282bf1fac6112285017366cb5f867469');
gr.query();
while(gr.next()){

    var role = 'f581eaad0a0a0bc500fbf9055d015838';
    var  spRole = new GlideRecord('sys_user_has_role');
    spRole.initialize();
    spRole.user = gr.getValue('user');
    spRole.role = role;
    spRole.insert();
}

Hope this helps 

Mark the answer correct if this helps you 

Thanks