kcimpulse

kcimpulse / SetCompany.BS

Last active June 28, 2017 14:58

	var SetBSEE = new GlideRecord('sys_user');
	SetBSEE.addEncodedQuery('emailENDSWITHbsee.gov');
	SetBSEE.query();
	while (SetBSEE.next()) {
	SetBSEE.company = 'e468c9fcdb2736008c1bfd0e0f9619fc';
	SetBSEE.update();
	}

	var SetBOEM = new GlideRecord('sys_user');
	SetBOEM.addEncodedQuery('emailENDSWITHboem.gov');

kcimpulse / BackfillAssignmentGroup.SI

Created May 19, 2017 16:44

ServiceNow - Script Includes - Backfill Assignment Group if user is selected first. & Update to Task Table, Assignment Group Refrence Field

	var BackfillAssignmentGroup = Class.create();
	BackfillAssignmentGroup.prototype = {
	initialize: function() {
	}, BackfillAssignmentGroup:function() {
	var gp = [];
	var a = current.assigned_to; //sys_user_grmember has the user to group relationship
	var grp = new GlideRecord('sys_user_grmember');
	if(a){
	grp.addQuery('user',a);
	}

kcimpulse / SetUsersTimeZone.BS

Created May 19, 2017 16:36

ServiceNow - OnDemand - Background Script to set all users TimeZones corresponding to their state. (USA Only)

	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();