relation, populate service from CI, cmdb_rel_ci

[Pastupe]

Im sorry to ask again but need help and also need to learn how to script this demand.

I can find way how to populate service on incident form if SD user select last appllication on the image below - 3

I havent luck to buil onchange client script - Im able to build script which returns me only direct relation ( from 3 to 2 ) but not what we need   ( from 3 to X)

would somebody give me a lesson here please ? Please note that I need onchange solution, so service is prefilled always when suer change CI

My system fields are

cmdb_ci   -- for apps

u_service_ci -- for service

thank you

/Petr

[mathew4]

Hi Travis works great now...thank you for explaining the components involved!

[mathew4]

Hi Travis, was trying to use the same logic in a business rule its working as expected, would like you know you expert opinion. In here instead of returning the string back i updated the current record from the script include itself

Business Rule:

function onAfter(current, previous) {

  var sbrq = new BusinessServiceFinder();

  sbrq.getServiceForCI();

}

Script Include:

var BusinessServiceFinder   = Class.create();    

BusinessServiceFinder.prototype = Object.extendsObject(AbstractAjaxProcessor, {    

  getServiceForCI: function() {    

      var this_is_variable_from_form = current.cmdb_ci;    

      return new JSON().encode(this._getParentRelationship(this_is_variable_from_form));

  },    

  _getParentRelationship: function(ciSysId) {    

      var o = new GlideRecord('cmdb_rel_ci'),  

          businessServices = [];    

      o.addQuery('child', ciSysId);    

      o.query();    

      while (o.next()) {    

          if (o.parent.sys_class_name == 'cmdb_ci_service') {    

              businessServices.push(o.getValue('parent')); // add the CI's sys_id to the return array  

          }    

          else {    

              businessServices = businessServices.concat(this._getParentRelationship(o.getValue('parent'))); // recursively execute the function for the parent's sys_id and join the returned businessServices array to the current array  

          }    

      }  

        var answernew = businessServices.join(',');    

        current.u_business_service_list =answernew;

            current.update();

            return businessServices;    

  },    

  type: 'BusinessServiceFinder'

})    

[tltoulson]

Hi Mathew,

Glad to hear its working for you!   Your modifications look good.   The one thing I will point out is that with a reference to current directly inside the Script Include, the Script Include can no longer be easily reused.   The Script Include is tightly coupled to the table and server side implementation.   This is not a problem, there is nothing intrinsically wrong with that approach, but you will find your scripts will be easier to test, troubleshoot, and repurpose if you establish a single responsibility for each script and maintain looser coupling.   In this case, I would divide up the responsibilities like this:

Business Rule: Manages the current record

Script Include: Retrieves an Array of parent Business Services for a given CI sys_id

The cool part is that if you look at my original Script Include, it is structured to be as reusable as possible:

BusinessServiceFinder.getServiceForCI: Brokers GlideAjax calls from the client to the BusinessServiceFinder functions

BusinessServiceFinder._getParentRelationship: Purely server side call that retrieves an array of parent Business Services for a given CI sys_id

I structure all of my GlideAjax script includes this way.   I have one function that is client callable and one that is server callable where the server callable performs all the real work and the client callable just brokers the AJAX parameters and response.   This allows me to use and test the Script Include easily from the server without requiring the GlideAjax client setup.   In your case, you could use the Script Include as is in the Business Rule like so:

function onBefore(current, previous) {
   var sbrq = new BusinessServiceFinder();
   var businessServices = sbrq._getParentRelationship(current.cmdb_ci);
   current.u_business_service_list = businessServices.join(',');
}

You will also notice that I changed it to a onBefore.   Since you are updating the current record, it is usually best to perform these before insert/update so that you aren't duplicating updates.

I hope this helps.

Kind regards,

Travis

[mathew4]

Bravo!...Thanks Travis

[sandeep299]

Hi @tltoulson ,

I am using your script to get all parent CI where the class is application and populating IT sytem owner from those parent Ci to the child glide list field and it is working when there is any insert of record in cmd_rel_ci Table.

I got challenge when i am trying to have it in a Fix script where we have 45k Cmdb relations. when i run this script its not working i am not sure is it due to array limitations or due to any recursive loops.

Can you please help here how to complete this requirement to update all the existing ci in a fix script.

Thanks