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

Revisions

  1. kcimpulse created this gist May 19, 2017.
    50 changes: 50 additions & 0 deletions SetUsersTimeZone.BS
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,50 @@
    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();
    }