SERVICENOW FUN

User Tools

Site Tools

Trace:
fix_scripts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
fix_scripts [01/22/2025 05:22] – johnsonjohnfix_scripts [11/22/2025 05:13] (current) – johnsonjohn
Line 1: Line 1:
 ======Fix Scripts====== ======Fix Scripts======
 ---- ----
 +
 +
 =====SLAs===== =====SLAs=====
-<code>+<code javascript sla-s.js>
 // P1 Resolution - 2 hour|26b995b51beb74504b8aa756624bcb75|P1 Resolution - 1 hour (Service Desk)|ce81803e1b70c914c4fec913604bcb1e| // P1 Resolution - 2 hour|26b995b51beb74504b8aa756624bcb75|P1 Resolution - 1 hour (Service Desk)|ce81803e1b70c914c4fec913604bcb1e|
 // P1 Response - 15 mins|a31795b51beb74504b8aa756624bcb59|P1 Response - 15 mins (Service Desk)|725188fa1b70c914c4fec913604bcbf0| // P1 Response - 15 mins|a31795b51beb74504b8aa756624bcb59|P1 Response - 15 mins (Service Desk)|725188fa1b70c914c4fec913604bcbf0|
Line 75: Line 77:
  
 =====01 Test Impersonate Group===== =====01 Test Impersonate Group=====
-<code>+<code javascript testImpersonatorGroup.js>
 //JWJ0215 2024 //JWJ0215 2024
 // Query the Group Members [sys_user_grmember] table to find members of the specified group // Query the Group Members [sys_user_grmember] table to find members of the specified group
Line 96: Line 98:
  
 =====02 Email Outbound===== =====02 Email Outbound=====
-<code>+<code javascript emailOutbound.js>
 //JWJ0215 2024 //JWJ0215 2024
 ClearUserLog(); ClearUserLog();
Line 115: Line 117:
  
 =====03 Cancel Scheduled Reports===== =====03 Cancel Scheduled Reports=====
-<code>+<code javascript cancelScheduledReports.js>
 //JWJ0215 2024 //JWJ0215 2024
 // 3.  Cancel all scheduled reports   ***sysauto_report.LIST***  set to active=false and run_type=5 on_demand // 3.  Cancel all scheduled reports   ***sysauto_report.LIST***  set to active=false and run_type=5 on_demand
Line 135: Line 137:
  
 =====04 Cancel CMDB Jobs===== =====04 Cancel CMDB Jobs=====
-<code>+<code javascript cancelCMDBjobs.js>
 //JWJ0215 2024 //JWJ0215 2024
 // 4.  Cancel all CMDB Schedules      // 4.  Cancel all CMDB Schedules     
Line 156: Line 158:
  
 =====05 Cert Scheduled List===== =====05 Cert Scheduled List=====
-<code>+<code javascript certScheduledList-ONDemand.js>
 //JWJ0215 2024 //JWJ0215 2024
 //5. cert_schedule.LIST second   run_type=5 on_demand   //5. cert_schedule.LIST second   run_type=5 on_demand  
Line 176: Line 178:
  
 =====06 Scheduled Data Collection===== =====06 Scheduled Data Collection=====
-<code>+<code javascript scheduledData.js>
 //JWJ0215 2024 //JWJ0215 2024
 // 6.  Cancel all 'Scheduled Data Collection' Jobs     ***sysauto_pa.LIST***    run_type=5 on_demand // 6.  Cancel all 'Scheduled Data Collection' Jobs     ***sysauto_pa.LIST***    run_type=5 on_demand
Line 196: Line 198:
  
 =====07 Cancel Data Mgmt===== =====07 Cancel Data Mgmt=====
-<code>+<code javascript cancelDataMGMT.js>
 // 7.  Set all Data Management Tasks to 'Cancelled'... // 7.  Set all Data Management Tasks to 'Cancelled'...
 // JWJ  03.13.24 // JWJ  03.13.24
Line 224: Line 226:
  
 =====08 SAM Killer===== =====08 SAM Killer=====
-<code>+<code javascript SAMKiller.js>
 // 8.  Set all SAM jobs to cancelled // 8.  Set all SAM jobs to cancelled
 //JWJ0215  SAM KILLER sys_trigger //JWJ0215  SAM KILLER sys_trigger
Line 244: Line 246:
  
 =====09 Data Collectors-On Demand===== =====09 Data Collectors-On Demand=====
-<code>+<code javascript dataCollectors-on-demand.js>
 //Cancel all Scheduled Data Collectors -Set to On Demand //Cancel all Scheduled Data Collectors -Set to On Demand
 // JWJ0215 07.02.24 // JWJ0215 07.02.24
Line 266: Line 268:
  
 =====10 LDAP Active-False===== =====10 LDAP Active-False=====
-<code>+<code javascript ldapActiveFalse.js>
 //JWJ0215 2024 //JWJ0215 2024
 //10. Set all LDAP OU DEFINITIONS to Active=false //10. Set all LDAP OU DEFINITIONS to Active=false
Line 286: Line 288:
  
 =====11 Turn off LDAP===== =====11 Turn off LDAP=====
-<code>+<code javascript turnOffLDAP.js>
 //JWJ0215 2024 //JWJ0215 2024
 //11. Set all LDAP Server to Active=false //11. Set all LDAP Server to Active=false
Line 306: Line 308:
  
 =====12 ECC Queue===== =====12 ECC Queue=====
-<code>+<code javascript eccQueue.js>
 //JWJ0215 2024 //JWJ0215 2024
 //Post upgrade 12 to clear all ECC_Queue tables per KB0547597 //Post upgrade 12 to clear all ECC_Queue tables per KB0547597
Line 319: Line 321:
 ---- ----
  
-=====SLAs===== +=====God Mode DEV===== 
-<code>+<code javascript godModeDEV.js> 
 +//  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 ***
 +}
 </code> </code>
 ---- ----
  
-=====SLAs===== +=====God Mode SAND===== 
-<code>+<code javascript godModeSAND.js> 
 +//  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 ***
 +}
 </code> </code>
 ---- ----
  
-=====SLAs===== +=====God Mode TEST===== 
-<code>+<code javascript godModeTEST.js> 
 +//  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 ***
 +}
 </code> </code>
 ---- ----
  
-=====SLAs===== +=====Theme Colors TEST===== 
-<code>+<code javascript themeColorsTEST.js> 
 +//  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 ***********************************************************
 +
 +}
 </code> </code>
 ---- ----
Line 348: Line 1454:
 </code> </code>
 ---- ----
 +
  
  
fix_scripts.1737552142.txt.gz · Last modified: by johnsonjohn
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki