Affected CI & auto populated of Impacted Services ?

[sukran]

Hi All ,

We try to auto populate the Impacted services based on affected CI in change/incident form , How to achieve this ?

As of now , if we choose CI in configuration item field , it will show the same CI in affected CI tab & want to populate impacted services related this CI

We have dependency map/relationship in CMDB , but we don't have Service mapping ITOM

[Ankur Bawiskar · Accepted solution]

Hi,

Steps below

1) create after insert BR on task_ci table with valid condition so that it works only for INC and CHG

2) then for each insert insert record into task_cmdb_ci_service with the value from CI and Task from Task CI Table

Condition: current.task.number.startsWith('CHG') || current.task.number.startsWith('INC')

Script:

(function executeRule(current, previous /*null when async*/) {

    // Add your code here

var gr = new GlideRecord('task_cmdb_ci_service');

gr.initialize();

gr.cmdb_ci_service = current.ci_item;

gr.task = current.task;

gr.insert();

})(current, previous);

Regards
Ankur

[sukran]

@Ankur Bawiskar - excellent , it added as expected 

Also if we remove any affected ci tab , that need to remove in Impacted services ??

The second point , below script i can try to get all child related CI to populated , is not works

var services = current.ci_item;

var gr= new GlideRecord('task_cmdb_ci_service');{
for (var i = 0; i < services.length; i++) {
gr.initialize();
gr.cmdb_ci_service = services[i];
gr.manually_added = false;
gr.insert();
}
},

[Ankur Bawiskar]

Hi,

for removal you would require Before delete BR on task_ci table

I didn't get what is requirement for 2nd point

Regards
Ankur

[sukran]

The second point 

affected CI --> Impacted services needs to auto populate -- under all child CI / services in related list

[Ankur Bawiskar]

@sukran 

Not much sure on that part.

Regards
Ankur