How to display/print the value of Configuration Item field of Task table via email script (condition mentioned in description below)?

rishabh31 · ‎08-30-2022

Dear Community,

Through email script how to get the value of field Configuration item (cmdb_ci) of Task table, condition is- it only displays its value when the 'name' of configuration item is of class (sys_class_name)- Computer (Only), rest for any other class it does not show Configuration Item on Tabular format

I tried below email script but not getting result please help, I am new on Coding.

template.print("<tr><td style=\"padding: 5px; border: 1px solid; border-color: grey;\" >");
template.print('Configuration item');
template.print("</td><td style=\"padding: 5px; border: 1px solid; border-color: grey;\" >");

var gr1 = new GlideRecord('cmdb_ci');
gr1.addQuery('name', current.getValue(cmdb_ci));
gr1.addQuery('sys_class_name', "Computer");
gr1.query();
if (gr1.next()) {

template.print(current.getValue(cmdb_ci) == gr1.sys_id);
template.print("</td></tr>");
}

template.print("</table>");

Please provide the revision on code, I shall be grateful.

Thanks!

Muhammad Khan · ‎08-30-2022

Overall Script would look like below.

 var gr1 = new GlideRecord('cmdb_ci');

    gr1.addQuery('name', current.getDisplayValue('cmdb_ci'));
    gr1.addQuery('sys_class_name', "cmdb_ci_computer");
    gr1.query();
    if (gr1.next()) {

      template.print(current.getDisplayValue('cmdb_ci'));
       template.print("</td></tr>");

    }

View solution in original post

rishabh31 · ‎08-30-2022

Thanks Muhammad its worked as expected, thanks for giving overview. Marked Correct & helpful.

Muhammad Khan · ‎08-30-2022

Glad to know it worked.