Fix Scripts

// 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

//JWJ0215 2024
ClearUserLog();
gs.setSession.setStrictQuery(true);
var emailsmpt = new GlideRecord ('sys_properties');      //name var
emailsmpt.addEncodedQuery('name=glide.email.smtp.active', 'false');     //add encoded filter
emailsmpt.query();
UserLog("I have found the " + emailsmpt + " that needs to be changed");     //log messge
while (emailsmpt.next()){     // set while with gr
	UserLog("changing " + emailsmpt + " value to true");     //log message
	emailsmpt.value = 'true';  //set 
	emailsmpt.update();  //update
	UserLog('Post Upgrade 2 ' + emailsmpt.value);  //log
}
gs.info('Post Upgrade 2 complete '); // was gs.info

//JWJ0215 2024
// 3.  Cancel all scheduled reports   ***sysauto_report.LIST***  set to active=false and run_type=5 on_demand
ClearUserLog();
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
	UserLog('Post Upgrade 3 complete' + schedreport);
}
gs.info('Post Upgrade 3 complete '); // was gs.info

//JWJ0215 2024
// 4.  Cancel all CMDB Schedules     
//cert_task.LIST   first   state=7 for cancelled
ClearUserLog();
gs.setSession.setStrictQuery(true);
var schedcmdb = new GlideRecord ('cert_task');
schedcmdb.addEncodedQuery(active=true);
schedcmdb.query();
UserLog("found " + schedcmdb.getRowCount() + " reports to update.");
while (schedcmdb.next()){
	UserLog("changing " + schedcmdb + " records to active-false.");
	schedcmdb.active = 'false';
	schedcmdb.update();
	UserLog('Post Upgrade 4 complete: ' + schedcmdb);
}
gs.info('Post Upgrade 4 complete '); // was gs.info

//JWJ0215 2024
//5. cert_schedule.LIST second   run_type=5 on_demand  
ClearUserLog();
gs.setSession.setStrictQuery(true);
var schedcert = new GlideRecord ('cert_schedule');
schedcert.addEncodedQuery('nameISNOTEMPTY^run_type!=on_demand');
schedcert.query();
UserLog("found " + schedcert.getRowCount() + " reports to update.");
while (schedcert.next()){
	UserLog("changing " + schedcert + " records to ON Demand.");
	schedcert.run_type = 'on_demand';
	schedcert.update();
	UserLog('Post Upgrade 5 complete: ' + schedcert);
}
gs.info('Post Upgrade 5 complete '); // was gs.info

//JWJ0215 2024
// 6.  Cancel all 'Scheduled Data Collection' Jobs     ***sysauto_pa.LIST***    run_type=5 on_demand
ClearUserLog();
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
	UserLog('Post Upgrade 6 complete: ' + schedreport);
}
gs.info('Post Upgrade 6 complete '); // was gs.info

// 7.  Set all Data Management Tasks to 'Cancelled'...
// JWJ  03.13.24
ClearUserLog();
UserLog("1. Starting 'data-management' script", "DATA-MANAGEMENT");
gs.setSession.setStrictQuery(true);
// --use a GlideRecord against the data management table  ****  our variable is 'grcmdbtask'
var grcmdbtask = new GlideRecord('cmdb_data_management_task');
// --create the query
grcmdbtask.addEncodedQuery('state=1^stateNOT IN3,4,7,8');
// --call the query
grcmdbtask.query();
UserLog("2. found " + grcmdbtask.getRowCount() + " records to update.", "DATA-MANAGEMENT");
while (grcmdbtask.next()) {
    // --flip the state over
    UserLog("3. changing: " + grcmdbtask.number + " to CANCELLED.", "DATA-MANAGEMENT");
     //grcmdbtask.getValue('cmdb_data_management_task');
     //grcmdbtask.getValue(grcmdbtask.sys_id);
    //UserLog(grcmdbtask.number);
    grcmdbtask.state = 'cancelled';
    grcmdbtask.update();
}
UserLog("Post Upgrade 7 complete: ", "DATA-MANAGEMENT");
gs.info('Post Upgrade 7 complete '); // was gs.info

// 8.  Set all SAM jobs to cancelled
//JWJ0215  SAM KILLER sys_trigger
ClearUserLog();
gs.setSession.setStrictQuery(true);
var skreport = new GlideRecord ('sys_trigger');      //name var
skreport.addEncodedQuery("nameLIKESAM -^trigger_typeISNOTEMPTY");     //add encoded filter
skreport.query();
UserLog("found " + skreport.getRowCount() + " records to update.");     //log messge
while (skreport.next()){     // set while with gr
	UserLog("changing " + skreport + " records to disabled.");     //log message
	skreport.trigger_type='2';  //set 
	skreport.update();  //update
	UserLog('Post Upgrade 8 complete: ' + skreport);  //log
}
gs.info('Post Upgrade 8 complete '); // was gs.info

//Cancel all Scheduled Data Collectors -Set to On Demand
// JWJ0215 07.02.24
ClearUserLog();
gs.setSession.setStrictQuery(true);
var dcollector = new GlideRecord ('sysauto_pa');
dcollector.addEncodedQuery(active=true);
dcollector.addEncodedQuery(run='On Demand');
dcollector.query();
UserLog("found " + dcollector.getRowCount() + " data collectors to update.");
while (dcollector.next()){
	UserLog("changing " + dcollector.sys_name + " records to active=false.");
	dcollector.active = 'false';
	dcollector.run = 'On Demand';
	dcollector.update();
	UserLog('Data Colectors set to Active=false ' + dcollector.sys_name);
}
gs.info('Post Upgrade 9 Complete ');

//JWJ0215 2024
//10. Set all LDAP OU DEFINITIONS to Active=false
ClearUserLog();
gs.setSession.setStrictQuery(true);
var ldapdef = new GlideRecord ('ldap_ou_config');
ldapdef.addEncodedQuery(active=true);
ldapdef.query();
UserLog("Found " + ldapdef.getRowCount() + " LDAP Definitions to update.");
while (ldapdef.next()) {
	gs.info("changing " + ldapdef + records to active=false.");
	ldapdef.active = 'false';
	ldapdef.update();
	UserLog("Post Upgrade 10 complete" + ldapdef);
}
gs.info('Post Upgrade 10 complete ');

//JWJ0215 2024
//11. Set all LDAP Server to Active=false
ClearUserLog();
gs.setSession.setStrictQuery(true);
var ldapserv = new GlideRecord ('ldap_server_url');
ldapserv.addEncodedQuery(active=true);
ldapserv.query();
UserLog("Found " + ldapserv.getRowCount() + " LDAP Server to update.");
while (ldapserv.next()) {
	gs.info("changing " + ldapserv + records to active=false.");
	ldapserv.active = 'false';
	ldapserv.update();
	UserLog("Post Upgrade 10 complete" + ldapserv);
}
gs.info('Post Upgrade 10 complete ');

//JWJ0215 2024
//Post upgrade 12 to clear all ECC_Queue tables per KB0547597
//  https://thedacaredev.service-now.com/nav_to.do?uri=%2Fsys_db_object_list.do%3Fsysparm_query%3Dsys_update_nameISNOTEMPTY%5ElabelLIKEqueue%26sysparm_first_row%3D1%26sysparm_view%3D%26sysparm_choice_query_raw%3D%26sysparm_list_header_search%3Dtrue
// filter by *queue   7 tables ecc_queue0000-0006
ClearUserLog();
var ecc = new GlideRecord('ecc_queue');
ecc.deleteMultiple();
UserLog('Post Upgrade 12: All ECC_queue tables are clear' + ecc.getRowCount());
gs.info('Post Upgrade 12 Complete ' + ecc.getRowCount());

//  JWJ 11.17.23
//  POST CLONE Script for specific instance
//define the instance names here
/*
Use this fix script if the theme of DEV INSTANCE is incorrect aftar an upgrade
1. Sets all Colors, 2. Enables Email Notifications, 3. Sets Email Redirection, 4. Disables LDAP Server Config, 5. Sets the Header Name, 6 removes testers from tester group, 7 cancels scheduled reports
8 cancels cmdb schedules, 9 sets cert schedule to on demand, 10 cancels data collection, 11 sets data management, 12 SAM Killer, 13 cancels data collectors, 14 sets ldap ou definitions, 15 ldap servers to active-false, 
16 clears all ecc queues, 17 notifications = false, 18 scheduled jobs active=false, 19 set favicon for instance.
*/
ClearUserLog();
var devInstance = "thedacaredev";
var prodInstance = "thedacare";
var devEmailRedirect = "thedacaredev@service-now.com";

//get this instance's name
var thisInstance = gs.getProperty("instance_name");
switch (thisInstance) {
    case devInstance:
        devConfig();
        break;
    case prodInstance:
        gs.print("**** You're running this script in production, are you asking for trouble?");
        break;
    default:
        gs.print("**** You are running in the incorrect instance " + thisInstance);
}

function devConfig() {
    //set colors
    //UserLog("css.base.color", "mediumseagreen"); // replace UserLog with gs.setProperty
	gs.setProperty("css.$nav-highlight-bar-active", "#ffd600");
	gs.setProperty("css.$nav-highlight-bar-inactive", "#ffd600");
	gs.setProperty("css.$nav-hr-color", "#ffd600");
	gs.setProperty("css.$navpage-header-bg", "#80bc00");
	gs.setProperty("css.$navpage-header-color", "#fffff");
	gs.setProperty("css.$navpage-header-divider-color", "#ffd600");
	gs.setProperty("css.$navpage-nav-bg", "#80bc00");
	gs.setProperty("css.$navpage-nav-bg-sub", "#80bc00");
	gs.setProperty("css.$navpage-nav-border", "#ffffff");
	gs.setProperty("css.$navpage-nav-color-sub", "#323e48");
	gs.setProperty("css.$navpage-nav-selected-bg", "#ffd600");
	gs.setProperty("css.$navpage-nav-selected-color", "#80bc00");
	gs.setProperty("css.$navpage-nav-unselected-color", "#ffffff");
	gs.setProperty("css.$subnav-background-color", "#ffd600");
	UserLog('1 Applied TEST Color Configs');

    //enable email notifications  2
    gs.setProperty("glide.email.read.active", true);
	gs.setProperty("glide.email.smtp.active", true);
	UserLog('2 Applied Email Configs');

    // redirect all messages
    gs.setProperty("glide.email.dev.user", devEmailRedirect);
	UserLog('3 Applied Email redirect');

    //disable all LDAP servers 4
    var ldap = new GlideRecord("ldap_server_config");
    ldap.query();
    while (ldap.next()) {
        active = false;
        ldap.update();
    }
	UserLog('4 Disabled LDAP Server');

    //5 set header name
    gs.setProperty("glide.product.description", "Service Management TEST");
    gs.print("Applied TEST Configurations"); // gs.print
	UserLog('5 Set Header Name Complete');
	
	//6 remove testers from test_impersonator group
	// Query the Group Members [sys_user_grmember] table to find members of the specified group
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('6 complete - number of users removed is ' + Count); // was gs.info

    // Delete the group member record
    grMember.deleteRecord();}
UserLog('6 complete:  Number of members removed '); // was gs.info
//***************** End ouf remove test users ***************

//************* begin cancel scheduled reports 3 ***************
// 7  Cancel all scheduled reports   ***sysauto_report.LIST***  set to active=false and run_type=5 on_demand
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
//UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	//UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
}
	UserLog('7 cancelled scheduled reports ');
// end **********************************************************

// begin 4 cancel CMDB jobs *************************************
// 8  Cancel all CMDB Schedules     
    //cert_task.LIST   first   state=7 for cancelled
gs.setSession.setStrictQuery(true);
var schedcmdb = new GlideRecord ('cert_task');
schedcmdb.addEncodedQuery(active=true);
schedcmdb.query();
//UserLog("found " + schedcmdb.getRowCount() + " reports to update.");
while (schedcmdb.next()){
	//UserLog("changing " + schedcmdb + " records to active-false.");
	schedcmdb.active = 'false';
	schedcmdb.update();
}
	UserLog('8 complete cancelled all cmdb schedules totalling ');
// end of 8 ******************************************************

//begin 9 ********************************************************
//5. cert_schedule.LIST second   run_type=5 on_demand  
gs.setSession.setStrictQuery(true);
var schedcert = new GlideRecord ('cert_schedule');
schedcert.addEncodedQuery('nameISNOTEMPTY^run_type!=on_demand');
schedcert.query();
//UserLog("found " + schedcert.getRowCount() + " reports to update.");
while (schedcert.next()){
	//UserLog("changing " + schedcert + " records to ON Demand.");
	schedcert.run_type = 'on_demand';
	schedcert.update();
}
	UserLog('9 complete. set reports to on demand ');
//end of 9 *******************************************************

// begin 10 ********************************************************
// 6.  Cancel all 'Scheduled Data Collection' Jobs     ***sysauto_pa.LIST***    run_type=5 on_demand
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
//UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	//UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
}
	UserLog('10 complete. cancelled scheduled data reports ');
// end 10 **********************************************************

//begin 11 ********************************************************
// 7.  Set all Data Management Tasks to 'Cancelled'...
// JWJ  03.13.24
//UserLog("Starting 'data-management' script", "DATA-MANAGEMENT");
gs.setSession.setStrictQuery(true);
// --use a GlideRecord against the data management table  ****  our variable is 'grcmdbtask'
var grcmdbtask = new GlideRecord('cmdb_data_management_task');
// --create the query
grcmdbtask.addEncodedQuery('state=1^stateNOT IN3,4,7,8');
// --call the query
grcmdbtask.query();
//UserLog("found " + grcmdbtask.getRowCount() + " records to update.", "DATA-MANAGEMENT");
while (grcmdbtask.next()) {
    // --flip the state over
    //UserLog("3. changing: " + grcmdbtask.number + " to CANCELLED.", "DATA-MANAGEMENT");
     //grcmdbtask.getValue('cmdb_data_management_task');
     //grcmdbtask.getValue(grcmdbtask.sys_id);
    //UserLog(grcmdbtask.number);
    grcmdbtask.state = 'cancelled';
    grcmdbtask.update();
}
UserLog("11 completed. ");
//end 11 ************************************************************

// begin 12 ********************************************************
// 8.  Set all SAM jobs to cancelled
//JWJ0215  SAM KILLER sys_trigger
gs.setSession.setStrictQuery(true);
var skreport = new GlideRecord ('sys_trigger');      //name var
skreport.addEncodedQuery("nameLIKESAM -^trigger_typeISNOTEMPTY");     //add encoded filter
skreport.query();
//UserLog("found " + skreport.getRowCount() + " records to update.");     //log messge
while (skreport.next()){     // set while with gr
	//UserLog("changing " + skreport + " records to disabled.");     //log message
	skreport.trigger_type='2';  //set 
	skreport.update();  //update
}
	UserLog('12 complete. sam killer ');  //log
// end 12 **********************************************************

//start 13 *********************************************************
//Cancel all Scheduled Data Collectors -Set to On Demand
// JWJ0215 07.02.24
gs.setSession.setStrictQuery(true);
var dcollector = new GlideRecord ('sysauto_pa');
dcollector.addEncodedQuery(active=true);
dcollector.addEncodedQuery(run='On Demand');
dcollector.query();
//UserLog("found " + dcollector.getRowCount() + " data collectors to update.");
while (dcollector.next()){
	//UserLog("changing " + dcollector.sys_name + " records to active=false.");
	dcollector.active = 'false';
	dcollector.run = 'On Demand';
	dcollector.update();
}
	UserLog('Data Colectors set to Active=false ');
// end 13 **********************************************************

// begin 14 *******************************************************
//JWJ0215 2024
//10. Set all LDAP OU DEFINITIONS to Active=false
gs.setSession.setStrictQuery(true);
var ldapdef = new GlideRecord ('ldap_ou_config');
ldapdef.addEncodedQuery(active=true);
ldapdef.query();
//UserLog("Found " + ldapdef.getRowCount() + " LDAP Definitions to update.");
while (ldapdef.next()) {
	ldapdef.active = 'false';
	ldapdef.update();
}
	UserLog("14 completed. set ldap ou definitions to false ");
// end 14 ***********************************************************

// begin 15 ******************************************************
//JWJ0215 2024
//11. Set all LDAP Server to Active=false
gs.setSession.setStrictQuery(true);
var ldapserv = new GlideRecord ('ldap_server_url');
ldapserv.addEncodedQuery(active=true);
ldapserv.query();
//UserLog("Found " + ldapserv.getRowCount() + " LDAP Server to update.");
while (ldapserv.next()) {
	ldapserv.active = 'false';
	ldapserv.update();
}
	UserLog("15 completed. ldap server active=false. ");
// end 15 ********************************************************

// begin 16 ******************************************************
//JWJ0215 2024
//Post upgrade to clear all ECC_Queue tables per KB0547597
//
var ecc = new GlideRecord('ecc_queue');
ecc.deleteMultiple();
//UserLog('16 completed: All ECC_queue tables are clear' + ecc.getRowCount());
UserLog('Post Upgrade 16 Complete ');
// end 16 ***********************************************************

//begin 17 ******************************************************
//JWJ0215 2024
// Make all Email Notifications Active=False
//
gs.setSession.setStrictQuery(true);
var emailact = new GlideRecord ('sysevent_email_action');
emailact.addEncodedQuery(active=true);
emailact.query();
//UserLog("Found " + emailact.getRowCount() + " Email Notifications to update.");
while (emailact.next()) {
	emailact.active = 'false';
	emailact.update();
	//UserLog("17 completed. Email Notifications set to active=false. " + Count);
}
UserLog('Post Upgrade 17 complete ');
// end 17 ********************************************************

//begin 18 ******************************************************
//JWJ0215 2024
// Set all Scheduled Jobs Active=False
//
gs.setSession.setStrictQuery(true);
var schedJobs = new GlideRecord ('sysauto');
schedJobs.addEncodedQuery(active=true);
schedJobs.query();
//UserLog("Found " + schedJobs.getRowCount() + " Scheduled Jobs Active=False");
while (schedJobs.next()) {
	schedJobs.active = 'false';
	schedJobs.update();
}
UserLog('18 Scheduled Jobs Active=False complete ');
// end 18 ********************************************************

//begin 19.  Attempt to set the favicon for the service Portal
//JWJ0215 07.17.24
//
gs.setProperty('glide.product.icon', 'faviconDEV.png');
gs.setProperty('glide.product.icon.icon', 'faviconDEV.png');
gs.setProperty('glide.product.icon.value', 'faviconDEV.png');
UserLog('The DEV favicon has been set to faviconDEV ');
// ***  End 19 ***
}

//  JWJ 11.17.23
//  POST CLONE Script for specific instance
//define the instance names here
/*
Use this fix script if the theme of DEV INSTANCE is incorrect aftar an upgrade
1. Sets all Colors, 2. Enables Email Notifications, 3. Sets Email Redirection, 4. Disables LDAP Server Config, 5. Sets the Header Name, 6 removes testers from tester group, 7 cancels scheduled reports
8 cancels cmdb schedules, 9 sets cert schedule to on demand, 10 cancels data collection, 11 sets data management, 12 SAM Killer, 13 cancels data collectors, 14 sets ldap ou definitions, 15 ldap servers to active-false, 
16 clears all ecc queues, 17 notifications = false, 18 scheduled jobs active=false, 19 set favicon for instance.
*/
ClearUserLog();
var sandInstance = "thedacaresand";
var prodInstance = "thedacare";
var sandEmailRedirect = "thedacaresand@service-now.com";

//get this instance's name
var thisInstance = gs.getProperty("instance_name");
switch (thisInstance) {
    case sandInstance:
        sandConfig();
        break;
    case prodInstance:
        gs.print("**** You're running this script in production, are you asking for trouble?");
        break;
    default:
        gs.print("**** You are running in the incorrect instance " + thisInstance);
}

function sandConfig() {
    //set colors
    //UserLog("css.base.color", "mediumseagreen"); // replace UserLog with gs.setProperty
	gs.setProperty("css.$nav-highlight-bar-active", "#ffd600");
	gs.setProperty("css.$nav-highlight-bar-inactive", "#ffd600");
	gs.setProperty("css.$nav-hr-color", "#ffd600");
	gs.setProperty("css.$navpage-header-bg", "#80bc00");
	gs.setProperty("css.$navpage-header-color", "#fffff");
	gs.setProperty("css.$navpage-header-divider-color", "#ffd600");
	gs.setProperty("css.$navpage-nav-bg", "#80bc00");
	gs.setProperty("css.$navpage-nav-bg-sub", "#80bc00");
	gs.setProperty("css.$navpage-nav-border", "#ffffff");
	gs.setProperty("css.$navpage-nav-color-sub", "#323e48");
	gs.setProperty("css.$navpage-nav-selected-bg", "#ffd600");
	gs.setProperty("css.$navpage-nav-selected-color", "#80bc00");
	gs.setProperty("css.$navpage-nav-unselected-color", "#ffffff");
	gs.setProperty("css.$subnav-background-color", "#ffd600");
	UserLog('1 Applied SAND Color Configs');

    //enable email notifications  2
    gs.setProperty("glide.email.read.active", true);
	gs.setProperty("glide.email.smtp.active", true);
	UserLog('2 Applied Email Configs');

    // redirect all messages
    gs.setProperty("glide.email.sand.user", sandEmailRedirect);
	UserLog('3 Applied Email redirect');

    //disable all LDAP servers 4
    var ldap = new GlideRecord("ldap_server_config");
    ldap.query();
    while (ldap.next()) {
        active = false;
        ldap.update();
    }
	UserLog('4 Disabled LDAP Server');

    //5 set header name
    gs.setProperty("glide.product.description", "Service Management SAND");
    gs.print("Applied SAND Configurations"); // gs.print
	UserLog('5 Set Header Name Complete');
	
	//6 remove testers from test_impersonator group
	// Query the Group Members [sys_user_grmember] table to find members of the specified group
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('6 complete - number of users removed is ' + Count); // was gs.info

    // Delete the group member record
    grMember.deleteRecord();}
UserLog('6 complete:  Number of members removed '); // was gs.info
//***************** End ouf remove test users ***************

//************* begin cancel scheduled reports 3 ***************
// 7  Cancel all scheduled reports   ***sysauto_report.LIST***  set to active=false and run_type=5 on_demand
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
//UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	//UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
}
UserLog('7 cancelled scheduled reports ');
// end **********************************************************

// begin 4 cancel CMDB jobs *************************************
// 8  Cancel all CMDB Schedules     
    //cert_task.LIST   first   state=7 for cancelled
gs.setSession.setStrictQuery(true);
var schedcmdb = new GlideRecord ('cert_task');
schedcmdb.addEncodedQuery(active=true);
schedcmdb.query();
//UserLog("found " + schedcmdb.getRowCount() + " reports to update.");
while (schedcmdb.next()){
	//UserLog("changing " + schedcmdb + " records to active-false.");
	schedcmdb.active = 'false';
	schedcmdb.update();
}
UserLog('8 complete cancelled all cmdb schedules totalling ');
// end of 8 ******************************************************

//begin 9 ********************************************************
//5. cert_schedule.LIST second   run_type=5 on_demand  
gs.setSession.setStrictQuery(true);
var schedcert = new GlideRecord ('cert_schedule');
schedcert.addEncodedQuery('nameISNOTEMPTY^run_type!=on_demand');
schedcert.query();
//UserLog("found " + schedcert.getRowCount() + " reports to update.");
while (schedcert.next()){
	//UserLog("changing " + schedcert + " records to ON Demand.");
	schedcert.run_type = 'on_demand';
	schedcert.update();
}
UserLog('9 complete. set reports to on demand ');
//end of 9 *******************************************************

// begin 10 ********************************************************
// 6.  Cancel all 'Scheduled Data Collection' Jobs     ***sysauto_pa.LIST***    run_type=5 on_demand
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
//UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	//UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
}
UserLog('10 complete. cancelled scheduled data reports ');
// end 10 **********************************************************

//begin 11 ********************************************************
// 7.  Set all Data Management Tasks to 'Cancelled'...
// JWJ  03.13.24
//UserLog("Starting 'data-management' script", "DATA-MANAGEMENT");
gs.setSession.setStrictQuery(true);
// --use a GlideRecord against the data management table  ****  our variable is 'grcmdbtask'
var grcmdbtask = new GlideRecord('cmdb_data_management_task');
// --create the query
grcmdbtask.addEncodedQuery('state=1^stateNOT IN3,4,7,8');
// --call the query
grcmdbtask.query();
//UserLog("found " + grcmdbtask.getRowCount() + " records to update.", "DATA-MANAGEMENT");
while (grcmdbtask.next()) {
    // --flip the state over
    //UserLog("3. changing: " + grcmdbtask.number + " to CANCELLED.", "DATA-MANAGEMENT");
     //grcmdbtask.getValue('cmdb_data_management_task');
     //grcmdbtask.getValue(grcmdbtask.sys_id);
    //UserLog(grcmdbtask.number);
    grcmdbtask.state = 'cancelled';
    grcmdbtask.update();
}
UserLog("11 completed. ");
//end 11 ************************************************************

// begin 12 ********************************************************
// 8.  Set all SAM jobs to cancelled
//JWJ0215  SAM KILLER sys_trigger
gs.setSession.setStrictQuery(true);
var skreport = new GlideRecord ('sys_trigger');      //name var
skreport.addEncodedQuery("nameLIKESAM -^trigger_typeISNOTEMPTY");     //add encoded filter
skreport.query();
//UserLog("found " + skreport.getRowCount() + " records to update.");     //log messge
while (skreport.next()){     // set while with gr
	//UserLog("changing " + skreport + " records to disabled.");     //log message
	skreport.trigger_type='2';  //set 
	skreport.update();  //update
}
UserLog('12 complete. sam killer ');  //log
// end 12 **********************************************************

//start 13 *********************************************************
//Cancel all Scheduled Data Collectors -Set to On Demand
// JWJ0215 07.02.24
gs.setSession.setStrictQuery(true);
var dcollector = new GlideRecord ('sysauto_pa');
dcollector.addEncodedQuery(active=true);
dcollector.addEncodedQuery(run='On Demand');
dcollector.query();
//UserLog("found " + dcollector.getRowCount() + " data collectors to update.");
while (dcollector.next()){
	//UserLog("changing " + dcollector.sys_name + " records to active=false.");
	dcollector.active = 'false';
	dcollector.run = 'On Demand';
	dcollector.update();
}
UserLog('Data Colectors set to Active=false ');
// end 13 **********************************************************

// begin 14 *******************************************************
//JWJ0215 2024
//10. Set all LDAP OU DEFINITIONS to Active=false
gs.setSession.setStrictQuery(true);
var ldapdef = new GlideRecord ('ldap_ou_config');
ldapdef.addEncodedQuery(active=true);
ldapdef.query();
//UserLog("Found " + ldapdef.getRowCount() + " LDAP Definitions to update.");
while (ldapdef.next()) {
	ldapdef.active = 'false';
	ldapdef.update();
}
UserLog("14 completed. set ldap ou definitions to false ");
// end 14 ***********************************************************

// begin 15 ******************************************************
//JWJ0215 2024
//11. Set all LDAP Server to Active=false
gs.setSession.setStrictQuery(true);
var ldapserv = new GlideRecord ('ldap_server_url');
ldapserv.addEncodedQuery(active=true);
ldapserv.query();
//UserLog("Found " + ldapserv.getRowCount() + " LDAP Server to update.");
while (ldapserv.next()) {
	ldapserv.active = 'false';
	ldapserv.update();
}
UserLog("15 completed. ldap server active=false. ");
// end 15 ********************************************************

// begin 16 ******************************************************
//JWJ0215 2024
//Post upgrade to clear all ECC_Queue tables per KB0547597
//
var ecc = new GlideRecord('ecc_queue');
ecc.deleteMultiple();
//UserLog('16 completed: All ECC_queue tables are clear' + ecc.getRowCount());
UserLog('Post Upgrade 16 Complete ');
// end 16 ***********************************************************

//begin 17 ******************************************************
//JWJ0215 2024
// Make all Email Notifications Active=False
//
gs.setSession.setStrictQuery(true);
var emailact = new GlideRecord ('sysevent_email_action');
emailact.addEncodedQuery(active=true);
emailact.query();
//UserLog("Found " + emailact.getRowCount() + " Email Notifications to update.");
while (emailact.next()) {
	emailact.active = 'false';
	emailact.update();
	//UserLog("17 completed. Email Notifications set to active=false. " + Count);
}
UserLog('Post Upgrade 17 complete ');
// end 17 ********************************************************

//begin 18 ******************************************************
//JWJ0215 2024
// Set all Scheduled Jobs Active=False
//
gs.setSession.setStrictQuery(true);
var schedJobs = new GlideRecord ('sysauto');
schedJobs.addEncodedQuery(active=true);
schedJobs.query();
//UserLog("Found " + schedJobs.getRowCount() + " Scheduled Jobs Active=False");
while (schedJobs.next()) {
	schedJobs.active = 'false';
	schedJobs.update();
}
UserLog('18 Scheduled Jobs Active=False complete ');
// end 18 ********************************************************

//begin 19.  Attempt to set the favicon for the service Portal
//JWJ0215 07.17.24
//
gs.setProperty('glide.product.icon', 'faviconSAND.png');
gs.setProperty('glide.product.icon.icon', 'faviconSAND.png');
gs.setProperty('glide.product.icon.value', 'faviconSAND.png');
UserLog('The DEV favicon has been set to faviconSAND ');
// ***  End 19 ***
}

//  JWJ 11.17.23
//  GOD MODE FIX SCRIPT
//THIS WILL TAKE THE PLACE OF ALL A_POST_UPGRADE FIX SCRIPTS.  YOU WILL NEED ONLY TO RUN THIS ONE.
/*
1. Sets all Colors, 2. Enables Email Notifications, 3. Sets Email Redirection, 4. Disables LDAP Server Config, 5. Sets the Header Name, 6 removes testers from tester group, 7 cancels scheduled reports
8 cancels cmdb schedules, 9 sets cert schedule to on demand, 10 cancels data collection, 11 sets data management, 12 SAM Killer, 13 cancels data collectors, 14 sets ldap ou definitions, 15 ldap servers to active-false, 
16 clears all ecc queues, 17 notifications = false, 18 scheduled jobs active=false, 19 set favicon for instance.
*/
ClearUserLog();
var testInstance = "thedacaretest";
var prodInstance = "thedacare";
var testEmailRedirect = "thedacaretest@service-now.com";

//get this instance's name
var thisInstance = gs.getProperty("instance_name");
switch (thisInstance) {
    case testInstance:
        testConfig();
        break;
    case prodInstance:
        gs.print("**** You're running this script in production, are you asking for trouble?");
        break;
    default:
        gs.print("**** You are running in the incorrect instance " + thisInstance);
}

function testConfig() {
    //set colors
    //UserLog("css.base.color", "mediumseagreen"); // replace UserLog with gs.setProperty
	gs.setProperty("css.$nav-highlight-bar-active", "#ffa400");
	gs.setProperty("css.$nav-highlight-bar-inactive", "#ffa400");
	gs.setProperty("css.$nav-hr-color", "#ffa400");
	gs.setProperty("css.$navpage-header-bg", "#c028b9");
	gs.setProperty("css.$navpage-header-divider-color", "#ffa400");
	gs.setProperty("css.$navpage-nav-bg", "#c028b9");
	gs.setProperty("css.$navpage-nav-bg-sub", "#c028b9");
	gs.setProperty("css.$navpage-nav-border", "#ffffff");
	gs.setProperty("css.$navpage-nav-selected-bg", "#f5333f");
	gs.setProperty("css.$navpage-nav-selected-color", "#323e48");
	gs.setProperty("css.$navpage-nav-unselected-color", "#ffffff");
	gs.setProperty("css.$subnav-background-color", "#f5333f");
	UserLog('1 Applied TEST Color Configs');

    //enable email notifications  2
    gs.setProperty("glide.email.read.active", true);
	gs.setProperty("glide.email.smtp.active", true);
	UserLog('2 Applied Email Configs');

    // redirect all messages
    gs.setProperty("glide.email.test.user", testEmailRedirect);
	UserLog('3 Applied Email redirect');

    //disable all LDAP servers 4
    var ldap = new GlideRecord("ldap_server_config");
    ldap.query();
    while (ldap.next()) {
        active = false;
        ldap.update();
    }
	UserLog('4 Disabled LDAP Server');

    //5 set header name
    gs.setProperty("glide.product.description", "Service Management TEST");
    gs.print("Applied TEST Configurations"); // gs.print
	UserLog('5 Set Header Name');
	
	//6 remove testers from test_impersonator group
	// Query the Group Members [sys_user_grmember] table to find members of the specified group
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('6 users removed from test_impersonator group'); // was gs.info

    // Delete the group member record
    grMember.deleteRecord();}
UserLog('6 complete  -All members have been removed from the test group '); // was gs.info
//***************** End ouf remove test users ***************

//************* begin cancel scheduled reports 3 ***************
// 7  Cancel all scheduled reports   ***sysauto_report.LIST***  set to active=false and run_type=5 on_demand
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
//UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	//UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
}
	UserLog('7 cancelled scheduled reports');
// end **********************************************************

// begin 4 cancel CMDB jobs *************************************
// 8  Cancel all CMDB Schedules     
    //cert_task.LIST   first   state=7 for cancelled
gs.setSession.setStrictQuery(true);
var schedcmdb = new GlideRecord ('cert_task');
schedcmdb.addEncodedQuery(active=true);
schedcmdb.query();
//UserLog("found " + schedcmdb.getRowCount() + " reports to update.");
while (schedcmdb.next()){
	//UserLog("changing " + schedcmdb + " records to active-false.");
	schedcmdb.active = 'false';
	schedcmdb.update();
}
	UserLog('8 complete cancelled all cmdb schedules ');
// end of 8 ******************************************************

//begin 9 ********************************************************
//5. cert_schedule.LIST second   run_type=5 on_demand  
gs.setSession.setStrictQuery(true);
var schedcert = new GlideRecord ('cert_schedule');
schedcert.addEncodedQuery('nameISNOTEMPTY^run_type!=on_demand');
schedcert.query();
//UserLog("found " + schedcert.getRowCount() + " reports to update.");
while (schedcert.next()){
	//UserLog("changing " + schedcert + " records to ON Demand.");
	schedcert.run_type = 'on_demand';
	schedcert.update();
}
	UserLog('9 complete. set reports to on demand ');
//end of 9 *******************************************************

// begin 10 ********************************************************
// 6.  Cancel all 'Scheduled Data Collection' Jobs     ***sysauto_pa.LIST***    run_type=5 on_demand
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
//UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	//UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
}
	UserLog('10 complete. cancelled scheduled data reports ');
// end 10 **********************************************************

//begin 11 ********************************************************
// 7.  Set all Data Management Tasks to 'Cancelled'...
// JWJ  03.13.24
//UserLog("Starting 'data-management' script", "DATA-MANAGEMENT");
gs.setSession.setStrictQuery(true);
// --use a GlideRecord against the data management table  ****  our variable is 'grcmdbtask'
var grcmdbtask = new GlideRecord('cmdb_data_management_task');
// --create the query
grcmdbtask.addEncodedQuery('state=1^stateNOT IN3,4,7,8');
// --call the query
grcmdbtask.query();
//UserLog("found " + grcmdbtask.getRowCount() + " records to update.", "DATA-MANAGEMENT");
while (grcmdbtask.next()) {
    // --flip the state over
    //UserLog("3. changing: " + grcmdbtask.number + " to CANCELLED.", "DATA-MANAGEMENT");
     //grcmdbtask.getValue('cmdb_data_management_task');
     //grcmdbtask.getValue(grcmdbtask.sys_id);
    //UserLog(grcmdbtask.number);
    grcmdbtask.state = 'cancelled';
    grcmdbtask.update();
}
UserLog('11 complete '); // was gs.info
//end 11 ************************************************************

// begin 12 ********************************************************
// 8.  Set all SAM jobs to cancelled
//JWJ0215  SAM KILLER sys_trigger
gs.setSession.setStrictQuery(true);
var skreport = new GlideRecord ('sys_trigger');      //name var
skreport.addEncodedQuery("nameLIKESAM -^trigger_typeISNOTEMPTY");     //add encoded filter
skreport.query();
//UserLog("found " + skreport.getRowCount() + " records to update.");     //log messge
while (skreport.next()){     // set while with gr
	//UserLog("changing " + skreport + " records to disabled.");     //log message
	skreport.trigger_type='2';  //set 
	skreport.update();  //update
}
UserLog('12 complete. sam killer ');  //log
// end 12 **********************************************************

//start 13 *********************************************************
//Cancel all Scheduled Data Collectors -Set to On Demand
// JWJ0215 07.02.24
gs.setSession.setStrictQuery(true);
var dcollector = new GlideRecord ('sysauto_pa');
dcollector.addEncodedQuery(active=true);
dcollector.addEncodedQuery(run='On Demand');
dcollector.query();
//UserLog("found " + dcollector.getRowCount() + " data collectors to update.");
while (dcollector.next()){
	//UserLog("changing " + dcollector.sys_name + " records to active=false.");
	dcollector.active = 'false';
	dcollector.run = 'On Demand';
	dcollector.update();
}
	UserLog('Data Colectors set to Active=false ');
// end 13 **********************************************************

// begin 14 *******************************************************
//JWJ0215 2024
//10. Set all LDAP OU DEFINITIONS to Active=false
gs.setSession.setStrictQuery(true);
var ldapdef = new GlideRecord ('ldap_ou_config');
ldapdef.addEncodedQuery(active=true);
ldapdef.query();
//UserLog("Found " + ldapdef.getRowCount() + " LDAP Definitions to update.");
while (ldapdef.next()) {
	ldapdef.active = 'false';
	ldapdef.update();
}
	UserLog("14 completed. set ldap ou definitions to false");
// end 14 ***********************************************************

// begin 15 ******************************************************
//JWJ0215 2024
//11. Set all LDAP Server to Active=false
gs.setSession.setStrictQuery(true);
var ldapserv = new GlideRecord ('ldap_server_url');
ldapserv.addEncodedQuery(active=true);
ldapserv.query();
//UserLog("Found " + ldapserv.getRowCount() + " LDAP Server to update.");
while (ldapserv.next()) {
	ldapserv.active = 'false';
	ldapserv.update();
}
	UserLog("15 completed. ldap server active=false. ");
// end 15 ********************************************************

// begin 16 ******************************************************
//JWJ0215 2024
//Post upgrade to clear all ECC_Queue tables per KB0547597
//
var ecc = new GlideRecord('ecc_queue');
ecc.deleteMultiple();
//UserLog('16 completed: All ECC_queue tables are clear' + ecc.getRowCount());
UserLog('Post Upgrade 16 Complete ' + ecc.getRowCount());
// end 16 ***********************************************************

//begin 17 ******************************************************
//JWJ0215 2024
// Make all Email Notifications Active=False
//
gs.setSession.setStrictQuery(true);
var emailact = new GlideRecord ('sysevent_email_action');
emailact.addEncodedQuery(active=true);
emailact.query();
//UserLog("Found " + emailact.getRowCount() + " Email Notifications to update.");
while (emailact.next()) {
	emailact.active = 'false';
	emailact.update();
}
	UserLog("17 completed. Email Notifications Active=False " );
// end 17 ********************************************************

//begin 18 ******************************************************
//JWJ0215 2024
// Set all Scheduled Jobs Active=False
//
gs.setSession.setStrictQuery(true);
var schedJobs = new GlideRecord ('sysauto');
schedJobs.addEncodedQuery(active=true);
schedJobs.query();
//UserLog("Found " + schedJobs.getRowCount() + " Set all Scheduled Reports to Active=False");
while (schedJobs.next()) {
	schedJobs.active = 'false';
	schedJobs.update();
}
	UserLog("18 completed. Scheduled Reports Active=False ");
// end 18 ********************************************************
	
//begin 19.  Attempt to set the favicon for the service Portal
//JWJ0215 07.17.24
//
gs.setProperty('glide.product.icon', 'faviconTEST.png');
gs.setProperty('glide.product.icon.icon', 'faviconTEST.png');
gs.setProperty('glide.product.icon.value', 'faviconTEST.png');
UserLog('The TEST favicon has been set to faviconTEST.png ');
// *** End 19 ***
}

//  JWJ 11.17.23
//  POST CLONE Script for specific instance
//define the instance names here
/*
Use this fix script if the theme of TEST INSTANCE is incorrect aftar an upgrade
1. Sets all Colors
2. Enables Email Notifications
3. Sets Email Redirection
4. Disables LDAP Server Config
5. Sets the Header Name
*/
ClearUserLog();
var testInstance = "thedacaretest";
var prodInstance = "thedacare";
var testEmailRedirect = "thedacaretest@service-now.com";

//get this instance's name
var thisInstance = gs.getProperty("instance_name");
switch (thisInstance) {
    case testInstance:
        testConfig();
        break;
    case prodInstance:
        gs.print("**** You're running this script in production, are you asking for trouble?");
        break;
    default:
        gs.print("**** You are running in the correct instance " + thisInstance);
}

function testConfig() {
    //set colors
    //UserLog("css.base.color", "mediumseagreen"); // replace UserLog with gs.setProperty
	gs.setProperty("css.$nav-highlight-bar-active", "#ffa400");
	gs.setProperty("css.$nav-highlight-bar-inactive", "#ffa400");
	gs.setProperty("css.$nav-hr-color", "#ffa400");
	gs.setProperty("css.$navpage-header-bg", "#c028b9");
	gs.setProperty("css.$navpage-header-divider-color", "#ffa400");
	gs.setProperty("css.$navpage-nav-bg", "#c028b9");
	gs.setProperty("css.$navpage-nav-bg-sub", "#c028b9");
	gs.setProperty("css.$navpage-nav-border", "#ffffff");
	gs.setProperty("css.$navpage-nav-selected-bg", "#f5333f");
	gs.setProperty("css.$navpage-nav-selected-color", "#323e48");
	gs.setProperty("css.$navpage-nav-unselected-color", "#ffffff");
	gs.setProperty("css.$subnav-background-color", "#f5333f");
	UserLog('1 Applied TEST Color Configs');

    //enable email notifications  2
    gs.setProperty("glide.email.read.active", true);
	gs.setProperty("glide.email.smtp.active", true);
	UserLog('2 Applied Email Configs');

    // redirect all messages
    gs.setProperty("glide.email.test.user", testEmailRedirect);
	UserLog('3 Applied Email redirect');

    //disable all LDAP servers 4
    var ldap = new GlideRecord("ldap_server_config");
    ldap.query();
    while (ldap.next()) {
        active = false;
        ldap.update();
    }
	UserLog('4 Disabled LDAP Server');

    //5 set header name
    gs.setProperty("glide.product.description", "Service Management TEST");
    gs.print("Applied TEST Configurations"); // gs.print
	UserLog('5 Set Header Name');
	
	//6 remove testers from test_impersonator group
	// Query the Group Members [sys_user_grmember] table to find members of the specified group
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('6 users removed from test_impersonator group'); // 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
//***************** End ouf remove test users ***************

//************* begin cancel scheduled reports 3 ***************
// 7  Cancel all scheduled reports   ***sysauto_report.LIST***  set to active=false and run_type=5 on_demand
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
	UserLog('7 cancelled scheduled reports' + schedreport);
}
gs.info('7 cancelled Scheduled Reports'); // was gs.info
// end **********************************************************

// begin 4 cancel CMDB jobs *************************************
// 8  Cancel all CMDB Schedules     
    //cert_task.LIST   first   state=7 for cancelled
gs.setSession.setStrictQuery(true);
var schedcmdb = new GlideRecord ('cert_task');
schedcmdb.addEncodedQuery(active=true);
schedcmdb.query();
UserLog("found " + schedcmdb.getRowCount() + " reports to update.");
while (schedcmdb.next()){
	UserLog("changing " + schedcmdb + " records to active-false.");
	schedcmdb.active = 'false';
	schedcmdb.update();
	UserLog('8 complete cancelled all cmdb schedules ' + schedcmdb);
}
gs.info('8 cancelled cmdb schedules '); // was gs.info
// end of 8 ******************************************************

//begin 9 ********************************************************
//5. cert_schedule.LIST second   run_type=5 on_demand  
gs.setSession.setStrictQuery(true);
var schedcert = new GlideRecord ('cert_schedule');
schedcert.addEncodedQuery('nameISNOTEMPTY^run_type!=on_demand');
schedcert.query();
UserLog("found " + schedcert.getRowCount() + " reports to update.");
while (schedcert.next()){
	UserLog("changing " + schedcert + " records to ON Demand.");
	schedcert.run_type = 'on_demand';
	schedcert.update();
	UserLog('9 complete. set reports to on demand ' + schedcert);
}
gs.info('Post Upgrade 5 complete. cancelled Cert Schedule '); // was gs.info
//end of 9 *******************************************************

// begin 10 ********************************************************
// 6.  Cancel all 'Scheduled Data Collection' Jobs     ***sysauto_pa.LIST***    run_type=5 on_demand
ClearUserLog();
gs.setSession.setStrictQuery(true);
var schedreport = new GlideRecord ('sysauto_report');
schedreport.addEncodedQuery(active=true);
schedreport.query();
UserLog("found " + schedreport.getRowCount() + " reports to update.");
while (schedreport.next()){
	UserLog("changing " + schedreport + " records to active-false.");
	schedreport.active = 'false';
	schedreport.update();
	UserLog('10 complete. cancelled scheduled data reports ' + schedreport);
}
gs.info('Post Upgrade 6 complete '); // was gs.info
// end 10 **********************************************************

//begin 11 ********************************************************
// 7.  Set all Data Management Tasks to 'Cancelled'...
// JWJ  03.13.24
UserLog("Starting 'data-management' script", "DATA-MANAGEMENT");
gs.setSession.setStrictQuery(true);
// --use a GlideRecord against the data management table  ****  our variable is 'grcmdbtask'
var grcmdbtask = new GlideRecord('cmdb_data_management_task');
// --create the query
grcmdbtask.addEncodedQuery('state=1^stateNOT IN3,4,7,8');
// --call the query
grcmdbtask.query();
UserLog("found " + grcmdbtask.getRowCount() + " records to update.", "DATA-MANAGEMENT");
while (grcmdbtask.next()) {
    // --flip the state over
    UserLog("3. changing: " + grcmdbtask.number + " to CANCELLED.", "DATA-MANAGEMENT");
     //grcmdbtask.getValue('cmdb_data_management_task');
     //grcmdbtask.getValue(grcmdbtask.sys_id);
    //UserLog(grcmdbtask.number);
    grcmdbtask.state = 'cancelled';
    grcmdbtask.update();
}
UserLog("11 completed. ", "DATA-MANAGEMENT");
gs.info('Post Upgrade 7 complete '); // was gs.info
//end 11 ************************************************************

// begin 12 ********************************************************
// 8.  Set all SAM jobs to cancelled
//JWJ0215  SAM KILLER sys_trigger
gs.setSession.setStrictQuery(true);
var skreport = new GlideRecord ('sys_trigger');      //name var
skreport.addEncodedQuery("nameLIKESAM -^trigger_typeISNOTEMPTY");     //add encoded filter
skreport.query();
UserLog("found " + skreport.getRowCount() + " records to update.");     //log messge
while (skreport.next()){     // set while with gr
	UserLog("changing " + skreport + " records to disabled.");     //log message
	skreport.trigger_type='2';  //set 
	skreport.update();  //update
	UserLog('12 complete. sam killer ' + skreport);  //log
}
gs.info('Post Upgrade 8 complete '); // was gs.info
// end 12 **********************************************************

//start 13 *********************************************************
//Cancel all Scheduled Data Collectors -Set to On Demand
// JWJ0215 07.02.24
gs.setSession.setStrictQuery(true);
var dcollector = new GlideRecord ('sysauto_pa');
dcollector.addEncodedQuery(active=true);
dcollector.addEncodedQuery(run='On Demand');
dcollector.query();
UserLog("found " + dcollector.getRowCount() + " data collectors to update.");
while (dcollector.next()){
	UserLog("changing " + dcollector.sys_name + " records to active=false.");
	dcollector.active = 'false';
	dcollector.run = 'On Demand';
	dcollector.update();
	UserLog('Data Colectors set to Active=false ' + dcollector.sys_name);
}
// end 13 **********************************************************

// begin 14 *******************************************************
//JWJ0215 2024
//10. Set all LDAP OU DEFINITIONS to Active=false
gs.setSession.setStrictQuery(true);
var ldapdef = new GlideRecord ('ldap_ou_config');
ldapdef.addEncodedQuery(active=true);
ldapdef.query();
UserLog("Found " + ldapdef.getRowCount() + " LDAP Definitions to update.");
while (ldapdef.next()) {
	ldapdef.active = 'false';
	ldapdef.update();
	UserLog("14 completed. set ldap ou definitions to false" + ldapdef);
}
gs.info('Post Upgrade 14 complete ');
// end 14 ***********************************************************

// begin 15 ******************************************************
//JWJ0215 2024
//11. Set all LDAP Server to Active=false
gs.setSession.setStrictQuery(true);
var ldapserv = new GlideRecord ('ldap_server_url');
ldapserv.addEncodedQuery(active=true);
ldapserv.query();
UserLog("Found " + ldapserv.getRowCount() + " LDAP Server to update.");
while (ldapserv.next()) {
	ldapserv.active = 'false';
	ldapserv.update();
	UserLog("15 completed. ldap server active=false. " + ldapserv);
}
gs.info('Post Upgrade 15 complete ');
// end 15 ********************************************************

// begin 16 ******************************************************
//JWJ0215 2024
//Post upgrade to clear all ECC_Queue tables per KB0547597
//
var ecc = new GlideRecord('ecc_queue');
ecc.deleteMultiple();
UserLog('16 completed: All ECC_queue tables are clear' + ecc.getRowCount());
gs.info('Post Upgrade 16 Complete ' + ecc.getRowCount());
// end 16 ***********************************************************

}