I need to add Affected CIs list to the Change Approval notification

[Dawid2]

Hello folks,

I'm in a need to add Affected CIs list to the Change Approval notification that is currently running against sysapproval_approver table.

Using available Fields on the notification doesn't seem to fit any of the requirements and I need to include the list of the Affected CI only on the approval notification against sysapproval_approver table.

Can this be achieved in any way? I have no idea how to script it as I don't know Javascript.

Thanks!

[Kalaiarasan Pus]

gr.addQuery('task', current.sys_approval);

Check the column name and correct this.

[Dawid2]

Thanks. I found out that column on this table is actually called "u_task", but after I corrected it, nothing is displayed on notification.

[Kalaiarasan Pus · Accepted solution]

Changed current.sysapproval too ?

gr.addQuery('u_task', current.sysapproval);

[Dawid2]

Works perfectly. Thank you Kalai and all of the folks who contributed!

[tomcollins]

Dawid, What were the final scripts that you created for the email notification including all affected CIs & impacted applications? -Thanks