group with no member

[s7]

1) Groups with no members should include the group manager as a member.

2) Deactivate the group if there are no members or group managers.

Please help me in code.

[AnubhavRitolia · Accepted solution]

Hi @s7  

Please find the script to be executed on Background Script or Fix Script to implement it :

var grps = new GlideRecord('sys_user_group');
// grps.addQuery('sys_id','4bccbb5397da51109b1dd200f153aff9');  /Used this sys_id to test for particular group
grps.addActiveQuery();
grps.query();

while(grps.next())
{
    //gs.print("grps");
    var grmember = new GlideRecord('sys_user_grmember');
    grmember.addQuery('group',grps.sys_id);
    grmember.query();

    if(!grmember.hasNext())
    {
       // gs.print('grmember');
        if(grps.manager)
        {
        //gs.print(grps.manager);
        var grpm = new GlideRecord('sys_user_grmember');
        grpm.initialize();
        grpm.group = grps.sys_id;
        grpm.user = grps.manager.sys_id;
        grpm.insert();
        } else {
            grps.active = false;
        }
    }
    grps.update();
}

IF want to implement it through Business rule or any server side script you can try below script:

var grps = <GlideRecord object of Group value> / may be like current.assignment_group etc.

while(grps.next())
{
    //gs.print("grps");
    var grmember = new GlideRecord('sys_user_grmember');
    grmember.addQuery('group',grps.sys_id); // if returning sys_id in grps variable than can replace 'grps.sys_id' with 'grps'
    grmember.query();

    if(!grmember.hasNext())
    {
       // gs.print('grmember');
        if(grps.manager)
        {
        //gs.print(grps.manager);
        var grpm = new GlideRecord('sys_user_grmember');
        grpm.initialize();
        grpm.group = grps.sys_id;
        grpm.user = grps.manager.sys_id;
        grpm.insert();
        } else {
            grps.active = false;
        }
    }
    grps.update();
}

[AnubhavRitolia]

Hi @s7  

I hope you want to run Background Script or Fix Script and implement this for all Groups present in system. OR are you looking to implement it for particular Group?

[s7]

Hi @AnubhavRitolia 

I want to implement this for all groups present in system, not for a particular group.

[AnubhavRitolia]

Hi @s7 

Already provided solution for both cases in my solution provided earlier. Just check once.

[AnubhavRitolia · Accepted solution]

Hi @s7  

Please find the script to be executed on Background Script or Fix Script to implement it :

var grps = new GlideRecord('sys_user_group');
// grps.addQuery('sys_id','4bccbb5397da51109b1dd200f153aff9');  /Used this sys_id to test for particular group
grps.addActiveQuery();
grps.query();

while(grps.next())
{
    //gs.print("grps");
    var grmember = new GlideRecord('sys_user_grmember');
    grmember.addQuery('group',grps.sys_id);
    grmember.query();

    if(!grmember.hasNext())
    {
       // gs.print('grmember');
        if(grps.manager)
        {
        //gs.print(grps.manager);
        var grpm = new GlideRecord('sys_user_grmember');
        grpm.initialize();
        grpm.group = grps.sys_id;
        grpm.user = grps.manager.sys_id;
        grpm.insert();
        } else {
            grps.active = false;
        }
    }
    grps.update();
}

IF want to implement it through Business rule or any server side script you can try below script:

var grps = <GlideRecord object of Group value> / may be like current.assignment_group etc.

while(grps.next())
{
    //gs.print("grps");
    var grmember = new GlideRecord('sys_user_grmember');
    grmember.addQuery('group',grps.sys_id); // if returning sys_id in grps variable than can replace 'grps.sys_id' with 'grps'
    grmember.query();

    if(!grmember.hasNext())
    {
       // gs.print('grmember');
        if(grps.manager)
        {
        //gs.print(grps.manager);
        var grpm = new GlideRecord('sys_user_grmember');
        grpm.initialize();
        grpm.group = grps.sys_id;
        grpm.user = grps.manager.sys_id;
        grpm.insert();
        } else {
            grps.active = false;
        }
    }
    grps.update();
}