Hi Paul,
In Change record Impact Services Tab, Business services details has been populated automatically based on Configuration Item.
I opened the CI checked the CI Relationship It is listing many classes and values ( ie., Depends on - Business Application, Runs on - Server application , Runs on - Linux server and Contained by - Business services classes and related values).
Now user is expecting only Business application & business services autopopulate in Impact services tab.
As suggested , I have created business rule and Service impact script include.
Finally Contained by - Business services only populating not the depends on business application values.
Please help me what should I update to retrieve the values(depends on business application class and values) in Impact services tab ?
PLease find the screenshot attached here.
I have created Business rule and script include below:
Test Affected CI
table : CIs Affected [task_ci]
After Insert
(function executeRule(current, previous /*null when async*/) {
var changeGR = current.task.getRefRecord();
var ciGR = current.ci_item.getRefRecord();
gs.log('changeGR --> '+changeGR);
new ServiceImpact().refreshWithCI(changeGR, ciGR);
})(current, previous);
Script Include : Service Impact
var ServiceImpact = Class.create();
ServiceImpact.prototype = {
initialize: function(debug) {
this.debug = (debug==true); //Use this if you want to flag debugging output
},
/*
Add Impacted Services if needed based on CI
*/
refreshWithCI: function(task, ci) {
var ciu = new CIUtils();
var services = ciu.servicesAffectedByCI(ci.sys_id);
gs.log('services --> '+services);
var servicesAdded = this.addServices(task, services);
if (servicesAdded.length > 0) {
for (var j = 0; j < servicesAdded.length; j++) {
var service = new GlideRecord("cmdb_ci_service");
service.get(services[j]);
if (this.debug) gs.addInfoMessage("" + task.number + " has a new Impacted Service: " + service.name);
}
}
},
/*
Update any missing Impacted Services, leaving existing records intact
*/
refresh: function(task) {
this.addAffectedServices(task);
task.update();
},
/*
Clear out and recalculate Impacted Services
*/
refreshFull: function(task) {
this.removeAffectedServices(task);
this.addAffectedServices(task);
task.update();
},
addAffectedServices: function(task) {
//Find all impacted business services
var ciu = new CIUtils2();
var services = ciu.cisAffectedByTask(task);
this.addServices(task, services);
},
addServices: function(task, services) {
var servicesAdded = [];
var m2m = new GlideRecord('task_cmdb_ci_service');
for (var i = 0; i < services.length; i++) {
var exists = this.isServiceImpact(task.sys_id, services[i]);
if (exists == false) {
m2m.initialize();
m2m.task = task.sys_id;
m2m.cmdb_ci_service = services[i];
m2m.manually_added = 'false';
m2m.insert();
servicesAdded.push(services[i]);
}
}
return servicesAdded;
},
isServiceImpact: function(task, service) {
var m2m = new GlideRecord('task_cmdb_ci_service');
m2m.addQuery('task', task);
m2m.addQuery('cmdb_ci_service', service);
m2m.addQuery('manually_added', 'false');
m2m.query();
return (m2m.getRowCount() > 0);
},
type: 'ServiceImpact'
};
/*--------------------- */
var ServiceImpact1 = Class.create();
ServiceImpact1.prototype = {
initialize: function(debug) {
this.debug = (debug==true); //Use this if you want to flag debugging output
},
/*
Add Business Application if needed based on CI
*/
refreshWithCI1: function(task, ci) {
var ciu = new CIUtils();
var businessapp = ciu.servicesAffectedByCI(ci.sys_id);
gs.log('businessapp --> '+businessapp);
var businessappAdded = this.addServices(task, businessapp);
if (businessappAdded.length > 0) {
for (var j = 0; j < businessappAdded.length; j++) {
var businessapp1 = new GlideRecord("u_cmdb_ci_business_app");
businessapp1.get(businessapp[j]);
if (this.debug) gs.addInfoMessage("" + task.number + " has a new Impacted Service: " + businessapp1.name);
}
}
},
/*
Update any missing Business Application, leaving existing records intact
*/
refresh1: function(task) {
this.addAffectedServices(task);
task.update();
},
/*
Clear out and recalculate Impacted Services
*/
refreshFull1: function(task) {
this.removeAffectedServices(task);
this.addAffectedServices(task);
task.update();
},
addAffectedServices: function(task) {
//Find all impacted business applications
var ciu = new CIUtils2();
var businessapp = ciu.cisAffectedByTask(task);
this.addServices(task, businessapp);
},
addServices: function(task, businessapp) {
var businessappAdded = [];
var m2m = new GlideRecord('task_cmdb_ci_service');
for (var i = 0; i < businessapp.length; i++) {
var exists = this.isServiceImpact1(task.sys_id, businessapp[i]);
if (exists == false) {
m2m.initialize();
m2m.task = task.sys_id;
m2m.u_cmdb_ci_business_app = businessapp[i];
m2m.manually_added = 'false';
m2m.insert();
businessappAdded.push(businessapp[i]);
}
}
return businessappAdded;
},
isServiceImpact1: function(task, service) {
var m2m = new GlideRecord('task_cmdb_ci_service');
m2m.addQuery('task', task);
m2m.addQuery('u_cmdb_ci_business_app', businessapp1);
m2m.addQuery('manually_added', 'false');
m2m.query();
return (m2m.getRowCount() > 0);
},
type: 'ServiceImpact1'
};
