daya
Kilo Explorer

I put this set of code on change_request table. In mail_script.

The following CI's will affected by this change:


var gr = new GlideRecord("task_ci");
gr.addQuery("task",current.sys_id);
gr.query();
while(gr.next())
{
template.print(' ' + gr.ci_item);// This give the sys_id of affected CI
var nameCI = new GlideRecord("cmdb_ci");
nameCI.addQuery("task_ci",gr.ci_item);
nameCI.query();
while(nameCI.next())
{
if(nameCI.sys_id == gr.ci_item){
template.print(' ' + nameCI.name); // This gives the name of sys_id of CI

}
}