question Add custom role to all users in ITSM forum

Add custom role to all users

Richard Tyler — Sun, 10 Mar 2019 13:36:07 GMT

i am developing a custom application on my PDI and have created a record producer to use on the service catalog. However, each time a user makes the request, i get an error message 'Requested record not found' . Adding the custom role to the user seems to resole the problem. But my organization has almost 5000 users and as such its not feasible to manually add the role to all users. I used the script below, which seems to add the role with 'empty in the tole field.

How do i make this work. and dynamically assign the role to all new users (we have LDAP) integration.

var gr = new GlideRecord("sys_user");

gr.query();

while(gr.next())

{

var role = new GlideRecord('sys_user_has_role');

role.addQuery('user',gr.sys_id);

role.addQuery('role', '<sys_id of Role>');

role.query();

if(!role.next())

{

role.initialize();

role.user = gr.sys_id; role.role = "<sys_id of Role>";

role.insert();

}

Re: Add custom role to all users

Abhishek Pidwa — Sun, 10 Mar 2019 13:44:15 GMT

If the role needs to be added to every user, I believe you can use this script described in this article:

https://docs.servicenow.com/bundle/london-application-development/page/script/useful-scripts/reference/r_AddRoleToEveryUser.html

After writing this , you can then schedule this job to run every day after your LDAP integration import.

Please mark this as solved if this solves your problem.

Thanks

Re: Add custom role to all users

Richard Tyler — Sun, 10 Mar 2019 20:55:00 GMT

Thanks Abjishek,

This worked perfectly.

Re: Add custom role to all users

Randall Arnold — Fri, 05 Jun 2020 13:47:22 GMT

I followed that example in a background script; no errors, but it doesn't add the role record (even though the script report seems to indicate it has). My code is below. Any ideas?

var gr = new GlideRecord('sys_user');
 gr.addQuery('user_name','my_user');//dummy name for public view
 gr.query();
 if (gr.next())
{
    gr.roles = gr.roles + ",change_approver";
    gr.update();
}

Re: Add custom role to all users

Edxavier Robert — Wed, 12 Aug 2020 01:15:11 GMT

Hi, I got the same question. Is not adding the role to the related links Role Tab.

Re: Add custom role to all users

Tushar Walveka2 — Thu, 26 Nov 2020 17:43:04 GMT

Try this script. It will add the roles in the related list as well.

//Find a user eg.abc
var gUser = new GlideRecord('sys_user');
gUser.addEncodedQuery('user_name=abc');
gUser.query();
if(gUser.next()){

//Declare roles in array
var arr = ["role1","role2","role3"];

//Assign the roles 
var grd = new GlideRecord('sys_user_has_role');
for(var i =0; i<arr.length; i++){
   grd.initialize();
   grd.user = gUser.sys_id;
   grd.setDisplayValue('role',arr[i]); 
   grd.insert();
 }

}

Re: Add custom role to all users

Tushar Walveka2 — Thu, 26 Nov 2020 17:44:09 GMT

Try this script

//Find a user eg.abc
var gUser = new GlideRecord('sys_user');
gUser.addEncodedQuery('user_name=abc');
gUser.query();
if(gUser.next()){

//Declare roles in array
var arr = ["role1","role2","role3"];

//Assign the roles 
var grd = new GlideRecord('sys_user_has_role');
for(var i =0; i<arr.length; i++){
   grd.initialize();
   grd.user = gUser.sys_id;
   grd.setDisplayValue('role',arr[i]); 
   grd.insert();
 }

}