Skip to content

Instantly share code, notes, and snippets.

@kcimpulse

kcimpulse/SetUsersTimeZone.BS

Created May 19, 2017 16:36
Show Gist options
  • Save kcimpulse/999a9ef956f4e8d8476688715acfcaa9 to your computer and use it in GitHub Desktop.
Save kcimpulse/999a9ef956f4e8d8476688715acfcaa9 to your computer and use it in GitHub Desktop.
Download ZIP
ServiceNow - OnDemand - Background Script to set all users TimeZones corresponding to their state. (USA Only)
Raw
SetUsersTimeZone.BS
var HiZone = new GlideRecord('sys_user');
HiZone.addEncodedQuery('stateSTARTSWITHhi');
HiZone.query();
while (HiZone.next()) {
HiZone.time_zone = "US/Hawaii";
HiZone.update();
}
var AkZone = new GlideRecord('sys_user');
AkZone.addEncodedQuery('stateSTARTSWITHak');
AkZone.query();
while (AkZone.next()) {
AkZone.time_zone = "US/Alaska";
AkZone.update();
}
var AzZone = new GlideRecord('sys_user');
AzZone.addEncodedQuery('stateSTARTSWITHaz');
AzZone.query();
while (AzZone.next()) {
AzZone.time_zone = "US/Arizona";
AzZone.update();
}
var PacZone = new GlideRecord('sys_user');
PacZone.addEncodedQuery('stateSTARTSWITHca^ORstateSTARTSWITHor^ORstateSTARTSWITHwa^ORstateSTARTSWITHnv');
PacZone.query();
while (PacZone.next()) {
PacZone.time_zone = "US/Pacific";
PacZone.update();
}
var MtnZone = new GlideRecord('sys_user');
MtnZone.addEncodedQuery('stateSTARTSWITHmt^ORstateSTARTSWITHnm^ORstateSTARTSWITHwy^ORstateSTARTSWITHid^ORstateSTARTSWITHut^ORstateSTARTSWITHco');
MtnZone.query();
while (MtnZone.next()) {
MtnZone.time_zone = "US/Mountain";
MtnZone.update();
}
var CenZone = new GlideRecord('sys_user');
CenZone.addEncodedQuery('stateSTARTSWITHnd^ORstateSTARTSWITHsd^ORstateSTARTSWITHne^ORstateSTARTSWITHks^ORstateSTARTSWITHok^ORstateSTARTSWITHtx^ORstateSTARTSWITHia^ORstateSTARTSWITHmo^ORstateSTARTSWITHar^ORstateSTARTSWITHla^ORstateSTARTSWITHwi^ORstateSTARTSWITHil^ORstateSTARTSWITHms^ORstateSTARTSWITHal^ORstateSTARTSWITHtn^ORstateSTARTSWITHmn^ORstateSTARTSWITHtex');
CenZone.query();
while (CenZone.next()) {
CenZone.time_zone = "US/Central";
CenZone.update();
}
var EstZone = new GlideRecord('sys_user');
EstZone.addEncodedQuery('stateSTARTSWITHmi^ORstateSTARTSWITHin^ORstateSTARTSWITHky^ORstateSTARTSWITHga^ORstateSTARTSWITHfl^ORstateSTARTSWITHoh^ORstateSTARTSWITHwv^ORstateSTARTSWITHme^ORstateSTARTSWITHvt^ORstateSTARTSWITHnh^ORstateSTARTSWITHma^ORstateSTARTSWITHri^ORstateSTARTSWITHct^ORstateSTARTSWITHny^ORstateSTARTSWITHpa^ORstateSTARTSWITHnj^ORstateSTARTSWITHde^ORstateSTARTSWITHmd^ORstateSTARTSWITHdc^ORstateSTARTSWITHva^ORstateSTARTSWITHnc^ORstateSTARTSWITHsc^ORstateSTARTSWITHd.c');
EstZone.query();
while (EstZone.next()) {
EstZone.time_zone = "US/Eastern";
EstZone.update();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment