Mail script: convert sys_id in event parameter to manager email address

[Cheski Frank]

Hi all,
I have a mail script for a mail notification where the event.parm1 refers to the sys_id of the user. Now I would like to use that data to add the *manager's* email address to CC.

What I did so far:

var gr = new GlideRecord('sys_user');
gr.get(event.parm1);
var mngr_email = gr.manager.email;
email.addAddress("cc", mngr_email, mngr);

What am I doing wrong?

Thanks and kind regards,
Cheski

[Ankur Bawiskar]

Hi,

update as this

var gr = new GlideRecord('sys_user');
gr.get(event.parm1);
var mngr_email = gr.manager.email;
email.addAddress("cc", mngr_email, gr.manager.name);

Regards
Ankur

[Ankur Bawiskar]

@Cheski Frank 

Did you try this?

This should also work fine.

Regards
Ankur

[Cheski Frank]

Thanks @Ankur Bawiskar . I already used the other approach but this one also looks great! Much appreciated 🙂

[Aman Kumar S · Accepted solution]

Hey,

var gr = new GlideRecord('sys_user');
if(gr.get(event.parm1)){
email.addAddress("cc", gr.manager.email.toString(), gr.getDisplayValue("manager"));
}