SERVICENOW FUN
https://snow.johnsonjohn.net/
2026-08-14T23:28:42+00:00SERVICENOW FUN
https://snow.johnsonjohn.net/
https://snow.johnsonjohn.net/lib/exe/fetch.php?media=wiki:dokuwiki.svgtext/html2026-06-29T20:19:57+00:00Anonymous (anonymous@undisclosed.example.com)background_scripts
https://snow.johnsonjohn.net/doku.php?id=background_scripts&rev=1782764397&do=diff
Background Scripts
----------
Approve
var app = new GlideRecord('sysapproval_approver');
app.addQuery('state','requested');
//app.setLimit(30);
app.query();
while(app.next())
{
gs.print('Approval count in requested state '+app.getRowCount());
app.state='approved';
app.update();
}text/html2026-06-29T20:19:57+00:00Anonymous (anonymous@undisclosed.example.com)bat_files
https://snow.johnsonjohn.net/doku.php?id=bat_files&rev=1782764397&do=diff
BAT Files
----------
Mapped Drives
rem 2.11.25
rem John Johnson
rem Network Drives on Lenovo Laptop NFDL-Lenovo
rem First delete if already there
net use A: /delete
net use D: /delete
net use I: /delete
net use L: /delete
net use M: /delete
net use O: /delete
net use P: /delete
net use S: /delete
net use T: /delete
net use W: /delete
net use Z: /delete
timeout /t 15 /nobreak
net use A: \\wis54937ts\apps /Persistent:yes /user:admin -Password-
net use D: \\wis54937ts\documents /Persiste…text/html2026-06-29T20:19:57+00:00Anonymous (anonymous@undisclosed.example.com)business_rules
https://snow.johnsonjohn.net/doku.php?id=business_rules&rev=1782764397&do=diff
Business Rules
----------
Project Insight Update
// JWJ0215 10.30.24 - Last tested on 10.30 @ 2.42 pm
// Project Insight Update Script
// This script will get needed data from the ServiceNow Project Request (before approved for a project), and
// push the data to Project Insight.
(function executeRule(current, previous /*null when async*/ ) {
var payload = {};
// get user from user table
var gr = new GlideRecord("sys_user");
gr.addQuery("sys_id", current.reque…text/html2026-06-29T20:19:57+00:00Anonymous (anonymous@undisclosed.example.com)certs
https://snow.johnsonjohn.net/doku.php?id=certs&rev=1782764397&do=diff
Certs
----------
PowerShell Certs
CSR Generator
## PowerShell Script to generate a Certificate Signing Request (CSR) using the SHA256 (SHA-256) signature algorithm and a 2048 bit key size (RSA) via the Cert Request Utility (certreq) ##
<#
JWJ0215 2023
#>
###
##
# YOU WILL NEED TO START ISE AS OTHER USER TO RUN....
####################
# Prerequisite check
####################
if (-NOT([Security.Principal.WindowsPrincipal][Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Sec…text/html2026-06-29T20:19:57+00:00Anonymous (anonymous@undisclosed.example.com)cleanup_scripts
https://snow.johnsonjohn.net/doku.php?id=cleanup_scripts&rev=1782764397&do=diff
Cleanup Scripts
Post Clone Cleanup Script
//JWJ0215 6.14.24
//Upload to PROD instance by navigating to system definition>upload file
//This file will LIVE in PROD so it will copy down when cloned. Do NOT RUN THIS IN PROD !!
// DO NOT MAKE THIS ACTIVE IN PRODUCTION
// ***** DEV begins on line 34 TEST begins on line 195 SAND begins on line 337 *****
//define the instance names here
TimestampLog("START POST CLONE Cleanup Script - Post_CLONE_Scripts");
var devInstance = "<instan…text/html2026-06-29T20:19:57+00:00Anonymous (anonymous@undisclosed.example.com)client_scripts
https://snow.johnsonjohn.net/doku.php?id=client_scripts&rev=1782764397&do=diff
Client Scripts
Variable Field read_only FALSE
g_form.setReadOnly('short_title', false);
----------
Incident
Assigned to/Assignment group change
function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
//Type appropriate comment here, and begin script below
if (newValue != oldValue) {
g_form.setMandatory("assigned_to",false);
}
}text/html2026-06-29T20:19:57+00:00Anonymous (anonymous@undisclosed.example.com)fix_scripts
https://snow.johnsonjohn.net/doku.php?id=fix_scripts&rev=1782764397&do=diff
Fix Scripts
----------
SLAs
// 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 h…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)flow_designer
https://snow.johnsonjohn.net/doku.php?id=flow_designer&rev=1782764398&do=diff
Flow Designer
----------
Application Asscess Tasks Status
(function execute(inputs, outputs) {
// ... code ...
var ritmSysID = inputs.ritmSysID
var grTask = new GlideRecord('sc_task');
grTask.addQuery('request_item', ritmSysID);
grTask.addQuery('active', true);
grTask.query();
if(grTask.hasNext()) {
outputs.taskscompleted = 'false';
}
else {
outputs.taskscompleted = 'true';
}
})(inputs, outpu…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)inbound_actions
https://snow.johnsonjohn.net/doku.php?id=inbound_actions&rev=1782764398&do=diff
Inbound Actions
----------
BCA PC
(function runAction(/*GlideRecord*/ current, /*GlideRecord*/ event, /*EmailWrapper*/ email, /*ScopedEmailLogger*/ logger, /*EmailClassifier*/ classifier) {
// Implement email action here
var subject = email.subject;
var workstation = subject.replace('ALERT: Node ','').replace(' is Down','').trim();
var gr = new GlideRecord('cmdb_ci');
gr.addQuery('name', workstation);
gr.query();
if (gr.hasNext()) {
while (gr.next()) {
current.…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)misc
https://snow.johnsonjohn.net/doku.php?id=misc&rev=1782764398&do=diff
Miscellaneous
----------
Multiple GETs
//Get Current Role
gs.hasRole('itil');
//Get Current User
javascript:gs.getUserID();
gs.getUser().getUserByID(current.approver).hasRole('itil');
//Get Instance Name
gs.getProperty("instance_name");
//Get Instance URL
gs.getProperty('glide.servlet.uri')text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)rest_messages
https://snow.johnsonjohn.net/doku.php?id=rest_messages&rev=1782764398&do=diff
REST MESSAGES
----------
Project Insight Get Updates
/*
// LINK
https://<instance>.service-now.com/now/nav/ui/classic/params/target/sys_rest_message.do%3Fsys_id%3D1f330e0c876d5610fdd876a6cebb358b%26sysparm_view%3D%26sysparm_record_target%3Dsys_rest_message%26sysparm_record_row%3D5%26sysparm_record_list%3DORDERBYname%26sysparm_record_rows%3D10
Description;
Get projects that have been updated in Project Insight
EndPoint; https://<TC>is-sandbox.projectinsight.net/api/thedacare-snow/g…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)scheduled_jobs_scripts
https://snow.johnsonjohn.net/doku.php?id=scheduled_jobs_scripts&rev=1782764398&do=diff
Scheduled Scripts
----------
Application Update Checker
// JWJ03.14.24 This will check all applications installed to see if there is an update
//run in xplore
ClearUserLog();
var apps =
new sn_appclient.AppsDataAPI()
.appsData
.getAllAppsWithVersions(false, true, false, false)['data']
apps.forEach(function(app) {
var hasUpdate =
app.version &&
app.active &&
app.latest_version != app.version &&
app.can_install_or_upgrade &&
app.isInsta…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)script_includes
https://snow.johnsonjohn.net/doku.php?id=script_includes&rev=1782764398&do=diff
Script Includes
----------
SP Entry Page
/**
*
* Service Portal sample script include to indicate
* 1. which login page should be used
* 2. the starting page after the user is authenticated
*
* Script is configured using system properties
* PROPERTY VALUE
* glide.entry.page.script new SPEntryPage().getLoginURL();
* glide.entry.first.page.script new SPEntryPage().getFirstPageURL();
*
* functions can return a path or null if no overrid…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)sidebar
https://snow.johnsonjohn.net/doku.php?id=sidebar&rev=1782764398&do=diff
<https://NorthFDL.com> Weather in North Fond du Lac, WI.
----------
Downloads
----------
PAGES
BAT FILES
----------
SCRIPTS
Background Scripts
Business Rules
Certs
Cleanup Scripts
Client Scripts
Fix Scripts
Flow Designer
Inbound Actions
Misc
Notification Email Scripts
Projects
Reference Qualifiers
Relationships
REST APIs
REST Messages
Scheduled Jobs Scripts
Script Includes
Service Portal
Syntax Editor Macros
Transform Scripts
UI Actions
UI Policies
UI Scripts
Upd…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)start_scripts
https://snow.johnsonjohn.net/doku.php?id=start_scripts&rev=1782764398&do=diff
BAT Files
----------
Shared Drives
rem 2.11.25
rem John Johnson
rem Network Drives on Lenovo Laptop NFDL-Lenovo
rem First delete if already there
net use A: /delete
net use D: /delete
net use I: /delete
net use L: /delete
net use M: /delete
net use O: /delete
net use P: /delete
net use S: /delete
net use T: /delete
net use W: /delete
net use Z: /delete
timeout /t 15 /nobreak
net use A: \\wis54937ts\apps /Persistent:yes /user:admin -Password-
net use D: \\wis54937ts\documents /Persiste…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)start
https://snow.johnsonjohn.net/doku.php?id=start&rev=1782764398&do=diff
Buttons
List Button
(function(){var myURL = window.location.href;myURL = decodeURIComponent(myURL);if ( myURL.indexOf("service-now.com/") < 0 && myURL.indexOf('wwwsnow') < 0 ){alert("Looks like you are not on a ServiceNow page.");return;}if ( myURL.indexOf("_list.do") > 0){alert("Looks like you are already in a List View, not a Form.");return;}var indexOfColonSlashSlash = myURL.indexOf("://");var indexOfFunctionPath = myURL.indexOf("/", indexOfColonSlashSlash + 3) + 1;var domainPath;var remain…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)syntax_editor_macros
https://snow.johnsonjohn.net/doku.php?id=syntax_editor_macros&rev=1782764398&do=diff
Syntax Editor Macros
----------
Client-Side Key Concepts
JWJ
//name jwj
//Text
//Client-Side Key Concepts
c_GeneratingMessages
c_GlideAjaxMethod
c_GlideRecordDatabaseAccess
c_GlideRecordGetReferenceDatabaseAccess
c_ReusableScript
c_ScratchpadDatabaseAccess
c_TryBlock
//Server-Side Key Concepts
s_AjaxFunctionDefinition
s_CurrentAndPreviousGlideRecordObjects
s_EventDefinitionAndTriggering
s_ExcelFileProcessing
s_GeneratingMessages
s_GlideRecordDatabaseAccess
s_GlideRecordDatabaseInsert
s_Ja…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)transform_scripts
https://snow.johnsonjohn.net/doku.php?id=transform_scripts&rev=1782764398&do=diff
Transform Scripts
----------
LDAP Transform
//JWJ0215 2022
// The manager coming in from LDAP is the DN value for the manager.
// The line of code below will locate the manager that matches the
// DN value and set it into the target record. To ignore the manager
// from LDAP, remove or comment out the line: ldapUtils.setManager(source, target);
//
// NOTE: The 'manager' field SHOULD NOT be mapped in the 'Field Maps' related list
// if the manager is brought in through an LDAP import. The…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)ui_actions
https://snow.johnsonjohn.net/doku.php?id=ui_actions&rev=1782764398&do=diff
UI ACTIONS
----------
Assign To Me
//Credit to: https://servicenowguru.com/system-ui/ui-actions-system-ui/client-server-code-ui-action/
//Onclick: runClientCode();
//Condition: gs.hasRole('itil')&& gs.getUser().isMemberOf(current.assignment_group.toString())
//Client-side 'onclick' function
function runClientCode(){
g_form.setMandatory("assigned_to",false);
//Call the UI Action and skip the 'onclick' function
gsftSubmit(null, g_form.getFormElement(), 'assignToMe'); //MUST call the 'Action…text/html2026-06-29T20:19:58+00:00Anonymous (anonymous@undisclosed.example.com)ui_scripts
https://snow.johnsonjohn.net/doku.php?id=ui_scripts&rev=1782764398&do=diff
UI SCRIPTS
----------
Enable Syntax Editor Macros
<?xml version="1.0" encoding="UTF-8"?>
<unload unload_date="2018-10-15 18:33:11">
<sys_ui_script action="INSERT_OR_UPDATE">
<active>true</active>
<description/>
<global>false</global>
<name>widgetMacros</name>
<script><![CDATA[(function(){
//object to store macros in
var macrosObj={
};
var fn = function(e){
var keyCode = e.keyCode || e.which;
//check if key pressed is TAB
if (keyCode == 9) {
//get D…text/html2026-06-29T20:19:59+00:00Anonymous (anonymous@undisclosed.example.com)update_sets
https://snow.johnsonjohn.net/doku.php?id=update_sets&rev=1782764399&do=diff
Update Sets
----------
Main Update Sets
----------
UserLog Complete Update Set
<?xml version="1.0" encoding="UTF-8"?><unload unload_date="2025-01-08 18:09:28">
<sys_remote_update_set action="INSERT_OR_UPDATE">
<application display_value="Global">global</application>
<application_name>Global</application_name>
<application_scope>global</application_scope>
<application_version/>
<collisions/>
<commit_date/>
<deleted/>
<description/>
<inserted/>
<name>JWJ-User Log Complete-2025 MAIN</name>
<o…text/html2026-06-29T20:20:00+00:00Anonymous (anonymous@undisclosed.example.com)xml
https://snow.johnsonjohn.net/doku.php?id=xml&rev=1782764400&do=diff
XML
----------
Capital Request Financial Analyst
<?xml version="1.0" encoding="UTF-8"?><unload unload_date="2023-09-27 15:42:43">
<sys_remote_update_set action="INSERT_OR_UPDATE">
<application display_value="Global">global</application>
<application_name>Global</application_name>
<application_scope>global</application_scope>
<application_version/>
<collisions/>
<commit_date/>
<deleted/>
<description/>
<inserted/>
<name>JWJ-Capital Request Financial Analysts</name>
<origin_sys_id/>
<parent di…