I was thinking something more like this for the after Insert Business Rule on the cmdb_ci_outage table:
(function executeRule(current, previous /*null when async*/ ) {
var affci = new GlideRecord ('task_ci');
affci.addQuery('ci_item', current.cmdb_ci);
affci.addQuery('task', current.task_number);
affci.query();
if (!affci.hasnext()) {
affci.initialize();
affci.ci_item = current.cmdb_ci;
affci.task = current.task_number;
affci.insert();
}
})(current, previous);
So on an incident, when an Outage record is created, you will now see a new record on the Affected CIs Related List on that same Incident with the CI used in the Outage - provided it wasn't already listed as an Affected CI, and the Configuration item field on the Incident remains unaffected.
Next create a Relationship. Name it whatever you want to appear on the tab. Applies to table = cmdb_ci. Queries from table = incident. Query with =
(function refineQuery(current, parent) {
var incArr = [];
var affci = new GlideRecord('task_ci');
affci.addQuery('ci_item', parent.sys_id);
affci.query();
while (affci.next()) {
incArr.push(affci.task.toString());
}
current.addQuery('sys_id', 'IN', incArr.join(','));
})(current, parent);
Once you add this new Related List to the CI form(s) you will see all of the incidents that have an Outage, and hence an Affected CI - or were otherwise added to the Affected CI Related List.
