ServiceNow Blog

var sQuery = 'sys_created_onONThis month@javascript:gs.beginningOfThisMonth()@javascript:gs.endOfThisMonth()'; checkDupl('question_answer', 'question', 'table_sys_id', sQuery); //checkDupl('question_answer', 'question', 'table_name', sQuery); function checkDupl(table, fieldParam1, fieldParam2, customQuery) {   var ga = new GlideAggregate(table);   ga.addAggregate('COUNT', fieldParam1);   if (customQuery) {     ga.addQuery(customQuery);   }   ga.groupBy(fieldParam1);   ga.addHaving('COUNT', '>', 1);   ga.query();   var dupls = [];      while (ga.next()) {     if (!gs.nil(ga.getDisplayValue(fieldParam1))) {       //dupls.push('checking question:::: ' + ga.getDisplayValue(fieldParam1));       var ga2 = new GlideAggregate(table);       ga2.addAggregate('COUNT', fieldParam2);       if (customQuery) {         ga2.addQuery(customQuery); ...

 ServiceNow get a list of item_option_new sysids based on question_answer sysids from records var endUserContainerSYSID = 'b902aa3ac3058b505c97bdac05013142'; var endUserReqSYSID = '2122627ac3058b505c97bdac0501310c'; var entitlementACRSYSID = '9f22a27ac3058b505c97bdac050131d1'; var roleACRSYSID = '6712ee3ac3058b505c97bdac0501313a'; var sEncQuery = 'table_sys_id=' + endUserContainerSYSID + '^ORtable_sys_id=' + endUserReqSYSID + '^ORtable_sys_id=' + entitlementACRSYSID + '^ORtable_sys_id=' + roleACRSYSID; var sysIDs = ''; var grQA = new GlideRecord('question_answer'); grQA.addEncodedQuery(sEncQuery); grQA.query(); while (grQA.next()) {   var ret = getItemOptionNewSYSIDs(grQA.question + '');   sysIDs = sysIDs + ret + ','; } var sListViewURL = 'https://dev183654.service-now.com/item_option_new_list.do?sysparm_query=sys_idIN' + sysIDs; gs.info ('FINAL URL: ' + sListViewURL); functi...

 var recSYSID = '1ba630c0c301c3105c97bdac050131a5'; var table = 'x_cls_clear_skye_i_group_operations'; getVarsSimple(recSYSID,table); getVarsComplex(recSYSID,table); function getVarsSimple(recSYSID, table) {   var now_GR = new GlideRecord(table);   gs.info('getvars SIMPLE:');   if (now_GR.get(recSYSID)) {     var variables = now_GR.variables.getElements();     for (var i = 0; i < variables.length; i++) {              var question = variables[i].getQuestion();       if (!gs.nil(question)&&question!=''){       gs.info('VARIABLE NAME:' + question.getLabel() + ", VARIABLE VALUE:" + question.getValue());       }     }   } } function getVarsComplex(recSYSID, table) {   var producerVars_allVars = new GlideRecord('question_answer');   producerVars_allVars.addQuery('table_sys_id', recSYSID);   //producerVars_allVars.addQuery('question.ty...

ServiceNow search for ACL by role  go to s ys_security_acl_role table