Important ServiceNow Script or Reference

ServiceNow Best Practice :

Attachment script Attachment Mandatory ---

if (g_form.getValue('non_tracked_devices') == 'Yes') {

var cat_id = g_form.getValue('sysparm_item_guid');

var gr = new GlideRecord("sys_attachment");

gr.addQuery("table_name", "sc_cart_item");

gr.addQuery("table_sys_id", cat_id);

alert("You must add an attachment before submitting this request.");

//Script to Delete multiple record

var psc = new GlideRecord(''); //Make sure table name is correct

psc.addEncodedQuery('sourceISNOTEMPTY');// Encoded Query or Filter if any required

psc.addQuery('sourceISNOTEMPTY');//Query or Filter if any required

psc.setLimit('10'); //Limit number of records

psc.setWorkflow(false); //Turn off business rule or notifications

//On Change Client script Example ... Disable or Enable the form

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

if (isLoading || newValue == '') {

var u1 = g_form.getValue('sitescope_manager'); //optional

g_form.addInfoMessage('Please wait while fetching Server Name');

g_form.getFormElement().disable();

var links = g_form.getFormElement().getElementsByTagName("a");

for ( i=0;i<links.length;i++)

var ga = new GlideAjax('Sitescope');

ga.addParam('sysparm_name','sitescope');

ga.addParam('sysparm_sitescope_manager',u1); //optional

function FolderFetch(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");

g_form.showFieldMsg('remote_server_name','There is some Congestion in the Network. Please try again Later','error');

var arr=outputval.split("\n");

g_form.addOption('remote_server_name', arr[k],arr[k]);

g_form.getFormElement().enable();

var links1 = g_form.getFormElement().getElementsByTagName("a");

for ( i=0;i<links1.length;i++)

//How to setup OAuth2 authentication for RESTMessageV2 integrations

//Find Duplicate record in table with filed value :

var gaDupCheck1 = new GlideAggregate('cmdb_ci_hardware');

gaDupCheck1.addAggregate('COUNT', 'serial_number');

gaDupCheck1.groupBy('serial_number');

gaDupCheck1.addHaving('COUNT', '>', 1);

while (gaDupCheck1.next()) {

dupRecords.push(gaDupCheck1.serial_number.toString());

//Script to delete duplicate records:

var dup = new GlideAggregate('dscy_router_interface');

dup.groupBy('mac_address');

var dup1 = new GlideRecord('dscy_router_interface');

dup1.addQuery('mac_address', dup.mac_address);

//CI Asset Synchronization useful scripts

var serialNum = [”SE415WS47”, ”VMware-42 26 87 93 04 f8 e6 15-9c 43 e6 c2 0e 76 4f 55”,];

for (var i = 0; i < serialNum.length; i++) {

var grCI = new GlideRecord("cmdb_ci_hardware");

grCI.addEncodedQuery('sys_class_name=cmdb_ci_computer');

grCI.addQuery("discovery_source", "MS SMS");

grCI.addQuery("serial_number", serialNum[i]);

var grAlm = new GlideRecord("alm_hardware");

grAlm.addQuery("serial_number", serialNum[i]);

grAlm.ci = grCI.sys_id.toString();

grAlm.setWorkflow(false);

var serialNum = ["1N44FW2", "1PR8YW2", "1QDKGP2"];

for (var i = 0; i < serialNum.length; i++) {

var grCI = new GlideRecord("cmdb_ci_hardware");

grCI.addEncodedQuery('sys_class_name=cmdb_ci_computer');

grCI.addQuery("discovery_source", "NULL");

grCI.addQuery("serial_number",serialNum[i]);

var grCI1 = new GlideRecord("cmdb_ci_hardware");

grCI1.addEncodedQuery('sys_class_name=cmdb_ci_computer');

grCI1.addQuery("discovery_source", "MS SMS");

grCI1.addQuery("serial_number", serialNum[i]);

grCI1.asset = grCI.asset;

// Manually Create record in windows Server or any other class using script

"className": "u_cmdb_ci_mongoose_web_server",

"name": "Mongoose@owa-sd-01",

"running_process_command": "c:\\clouddimensions\\mongoose.exe",

"sys_class_name": "u_cmdb_ci_mongoose_web_server"

"className": "cmdb_ci_win_server",

var jsonUtil = new JSON();

var input = jsonUtil.encode(payload);

var output = SNC.IdentificationEngineScriptableApi.createOrUpdateCI(‘ServiceNow’, input);

Remove Middle name from a name in Excel Sheet .

Using formula may be a very easy way for most of Excel users.

Select a blank cell next to the name list, and type this formula =TRIM(LEFT(A1,FIND(" ",LOWER(A1),1))) & " " & TRIM(MID(A1,FIND(" ",LOWER(A1),FIND(" ",LOWER(A1),1)+1)+1,LEN(A1)-FIND(" ",LOWER(A1),1)+1)) into it, then press Enter button on the keyboard and drag the Auto Fill handle to fill the range needed to apply the formula. Now you can see all the name of the list are shown in the new column without middle initials.

// Get all the incidents updated 3 days beforevar dupRecords = [];var count = '';var gr = new GlideRecord('incident');gr.addQuery('sys_updated_onRELATIVEGE@dayofweek@ago@3');gr.query();while(gr.next()){dupRecords.push(gr.number);}

gs.print(dupRecords);

Please hit or mark helpful !!

Labels: