Skip to main content

ServiceNow: use updateMultiple() to bulk update incident location field

 

gs.log ('script start', 'fixScr:bulkUpdateIncLocation''); var bUpdate=true; //bUpdate=false; var grIncs= new GlideRecord('incident'); grIncs.addNullQuery('location'); grIncs.addQuery('service_portfolio','76aea709db7a9300ba27aa484b96xxxx'); grIncs.addQuery('opened_by','83914c06dbd6101081fb49a2xxxxxxx');//--Dynatrace User grIncs.query(); gs.log('TOTAL: ' + grIncs.getRowCount(), 'fixScr:bulkUpdateIncLocation'); if (bUpdate){ grIncs.autoSysFields(false);//--leave last updated datetime stamp intact grIncs.setWorkflow(false);//--skip business rules grIncs.setValue('location', '533d13781b641154d4802f0a2xxxxxxx');//--Dynatrace grIncs.updateMultiple(); } gs.log ('script end', 'fixScr:bulkUpdateIncLocation'');

Comments

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

URL link in addInfoMessage

var ga=new GlideAjax('gld_HR_ajax'); ga.addParam('sysparm_name', 'checkEmployeeNumber_hrProfile'); ga.addParam('sysparm_hrprofilenumber', g_form.getValue('number')); ga.addParam('sysparm_employeenumber', newValue); ga.getXMLAnswer(function(answer) { if (answer!='undefined' && answer!=''){ var navURL="<a style='text-decoration:underline;color:blue' href=hr_profile.do?sysparm_query=number=" + answer + ">" + answer + "</a><img width='3' src='images/s.gif'/>"; var sMsg='The employee number entered already exists on another HR Profile ' + navURL; //alert(sMsg); g_form.showErrorBox('employee_number', 'error - please check'); g_form.addInfoMessage(sMsg); } });