// P1 Resolution - 2 hour|26b995b51beb74504b8aa756624bcb75|P1 Resolution - 1 hour (Service Desk)|ce81803e1b70c914c4fec913604bcb1e|
// P1 Response - 15 mins|a31795b51beb74504b8aa756624bcb59|P1 Response - 15 mins (Service Desk)|725188fa1b70c914c4fec913604bcbf0|
// P2 Resolution - 4 hours|55ea15b91beb74504b8aa756624bcbec|P2 Resolution - 8 hours (Service Desk)|4031c4fa1b70c914c4fec913604bcbe1|
// P2 Response - 1 hour |7a3a51791beb74504b8aa756624bcba9|P2 Response - 1 hour (Service Desk)|3a0180fa1b70c914c4fec913604bcbdf|
// P3 Resolution - 18 hours|d45b59b91beb74504b8aa756624bcb27|P3 Resolution - 1 day (Service Desk)|25e00cba1b70c914c4fec913604bcbc0|
// P3 Response - 4 hours |621b91791beb74504b8aa756624bcbaa|P3 Response - 4 hours (Service Desk)|1cc00cba1b70c914c4fec913604bcb04|
// P4 Resolution - 45 hours|9fdbd5791beb74504b8aa756624bcba7|P4 Resolution - 2 days (Service Desk)|aa90c4ba1b70c914c4fec913604bcbfc|
// P4 Response - 9 hours |31ab51f91beb74504b8aa756624bcb82|P4 Response - 8 hours (Service Desk)|8660c0ba1b70c914c4fec913604bcb01|
// P5 Resolution - 90 hours|4b9a4e5b1b22415099e265b1604bcba2|Apply New| |
// P5 Response - 18 hours|0a1c15f91beb74504b8aa756624bcb92|P5 Response - 40 hours (Service Desk)|1d9e77e61b70c914c4fec913604bcbd3|

var seek = 'P2 Response - 1 hour (Service Desk)';
var seekSysID = '3a0180fa1b70c914c4fec913604bcbdf';
var replace = 'P2 Response - 1 hour';
var replaceSysID = '7a3a51791beb74504b8aa756624bcba9';

var gr = new GlideRecord('task_sla');
gr.addQuery('sla', seekSysID);
//gr.setLimit(10);
gr.query();

gs.print(gr.getRowCount());

var incident = '';
while (gr.next()) {
    incident = gr.task;
    var inc = new GlideRecord('task_sla');
    inc.addQuery('task', incident);
    inc.query();

    // Replace SLA's for incidents with only a single response and resolution SLA applied
    if (inc.getRowCount() <= 2) {
        gs.print(gr.task.number);
        var check = [];
        while (inc.next()) {
            check.push(inc.sla.name.getDisplayValue());
        }
        gs.print(check.join(','));
        gs.print(check.indexOf(seek));
        gs.print(check.indexOf(replace));
        gs.print ("Replace " + seek + " with " + replace);
        gr.sla = replaceSysID;
        gr.setWorkFlow(false);
        gr.update();
    }

    // Replace SLA's for incidents with more than a single response and resolution SLA applied
    if (inc.getRowCount() > 2) {
        gs.print(gr.task.number);
        var check = [];
        while (inc.next()) {
            check.push(inc.sla.name.getDisplayValue());
        }
        gs.print(check.join(','));
        gs.print(check.indexOf(seek));
        gs.print(check.indexOf(replace));
        if ((check.indexOf(seek) >= 0) && (check.indexOf(replace) < 0)) {
            gs.print ("Replace " + seek + " with " + replace);
            gr.sla = replaceSysID;
            gr.setWorkFlow(false);
			gr.update();
        } else if ((check.indexOf(seek) >= 0) && (check.indexOf(replace) >= 0)) {
            gs.print("Delete " + seek);
            gr.deleteRecord();
        }
    }
}

//JWJ0215 2024
// Query the Group Members [sys_user_grmember] table to find members of the specified group
ClearUserLog();
var groupSysId = '9360165397e886103e1432890353af54'; // test_impersonator group  
var grMember = new GlideRecord('sys_user_grmember');
grMember.addQuery('group', groupSysId);
grMember.query();

// Log the user's Sys ID being removed - for audit purposes 
while (grMember.next()) {
    UserLog('Post Upgrade 1: Removing user with Sys ID: ' + grMember.user + ' from group: ' + groupSysId); // was gs.info

    // Delete the group member record
    grMember.deleteRecord();}
gs.info('Post Upgrade 1 complete:  -All members have been removed from the group, test_impersonator, with Sys ID: ' + groupSysId); // was gs.info