Differences

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

--- fix_scripts [01/22/2025 05:11] – johnsonjohn
+++ fix_scripts [12/31/2025 05:40] (current) – removed johnsonjohn
@@ Line 1: / Line 1: @@
-======Fix Scripts======
-----
-=====SLAs=====
-<code>
-// 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();
-        }
-    }
-}
-</code>
-----
-=====Test Impersonate Group=====
-<code>
-//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
-</code>
-----