How to remove users, roles and set the group fileds empty from workflow run script

[Brahmi Pandla]

@Ankur Bawiskar ,

I am trying to delete the group members and set the group values empty with below workflow run script

but not working

var grpId = current.variables.u_existing_group;

//set the group fileds empty

var gr = new GlideRecord('sys_user_group');

gr.addQuery('group',grpId);

gr.query();

if(gr.next()){

    gr.parent = '';  //Reference filed

    gr.default_assignee = '';  //Reference filed

    gr.type = '';  //Reference filed

    gr.active = 'false';

    gr.update();

}

//Remove group members

var grRemoveMember = new GlideRecord('sys_user_grmember');

grRemoveMember.addQuery('group', grpId);

grRemoveMember.addQuery("user", 'IN', grpId);

grRemoveMember.query();

while(grRemoveMember.next()){

    grRemoveMember.deleteRecord();

}

[Ankur Bawiskar · Accepted solution]

@Brahmi Pandla 

what does this variable u_existing_group hold?

Is it a group sysId?

If yes then update as this

var grpId = current.variables.u_existing_group;
 
// set the group fileds empty
 
var gr = new GlideRecord('sys_user_group');
gr.addQuery('sys_id',grpId);
gr.query();
if(gr.next()){
    gr.parent = '';
    gr.default_assignee = '';
    gr.type = '';
    gr.active = 'false';
    gr.update();
}
//Delete group members
var grRemoveMember = new GlideRecord('sys_user_grmember');
grRemoveMember.addQuery('group', grpId);
grRemoveMember.query();
while(grRemoveMember.next()){
    grRemoveMember.deleteRecord();
}

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

[Ankur Bawiskar · Accepted solution]

@Brahmi Pandla 

what does this variable u_existing_group hold?

Is it a group sysId?

If yes then update as this

var grpId = current.variables.u_existing_group;
 
// set the group fileds empty
 
var gr = new GlideRecord('sys_user_group');
gr.addQuery('sys_id',grpId);
gr.query();
if(gr.next()){
    gr.parent = '';
    gr.default_assignee = '';
    gr.type = '';
    gr.active = 'false';
    gr.update();
}
//Delete group members
var grRemoveMember = new GlideRecord('sys_user_grmember');
grRemoveMember.addQuery('group', grpId);
grRemoveMember.query();
while(grRemoveMember.next()){
    grRemoveMember.deleteRecord();
}

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

[Brahmi Pandla]

Hi Ankur,

Thanks for Response

u_existing_group is catalog variable name it holds  group sys is only

[Ankur Bawiskar]

@Brahmi Pandla 

then script I shared will work

[Brahmi Pandla]

Hi @Ankur Bawiskar 

Thanks for solution  Could you please provide the script for remove roles