Fix script to add user to a group

avinashdubey103
Tera Guru

Hi , i have written a fix script to add users to group(Users whose manager type is TL)

 

The code is running but it is not saving anything in the group :

Code:

var groupId = '91dd613d1b0ffd14f07bdbdee54bcb0f';
var count=0;// Replace with the actual group
if (groupId) {
   
        var group = new GlideRecord('sys_user_group');
        if (group.get(groupId)) {
            var usergR = new GlideRecord('sys_user');
            usergR.addQuery('u_manager_type', 'TL');
            usergR.query();
            while (usergR.next()) {
                if (!usergR.isMemberOf(groupId)) {
                    usergR.addMember(groupId);
                    count++;
               }
            }
        }

    }

    gs.print("count"+count);
1 ACCEPTED SOLUTION

Harish KM
Kilo Patron
Kilo Patron

HI @avinashdubey103 Can you try below script

 

var groupId = '91dd613d1b0ffd14f07bdbdee54bcb0f';
var count=0;// Replace with the actual group
if (groupId) {
var group = new GlideRecord('sys_user_group');
if (group.get(groupId)) {
var usergR = new GlideRecord('sys_user');
usergR.addQuery('u_manager_type', 'TL');
usergR.query();
while (usergR.next()) {
if (!usergR.isMemberOf(groupId)) {
var gr = new GlideRecord('sys_user_grmember');
gr.initialize();
gr.group = groupId;
gr.user = usergR.sys_id;
gr.insert();
}
}
}

}

Regards
Harish

View solution in original post

1 REPLY 1

Harish KM
Kilo Patron
Kilo Patron

HI @avinashdubey103 Can you try below script

 

var groupId = '91dd613d1b0ffd14f07bdbdee54bcb0f';
var count=0;// Replace with the actual group
if (groupId) {
var group = new GlideRecord('sys_user_group');
if (group.get(groupId)) {
var usergR = new GlideRecord('sys_user');
usergR.addQuery('u_manager_type', 'TL');
usergR.query();
while (usergR.next()) {
if (!usergR.isMemberOf(groupId)) {
var gr = new GlideRecord('sys_user_grmember');
gr.initialize();
gr.group = groupId;
gr.user = usergR.sys_id;
gr.insert();
}
}
}

}

Regards
Harish