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

Cheski Frank
Tera Contributor

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

1 ACCEPTED SOLUTION

Aman Kumar S
Kilo Patron

Hey,

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

 

Best Regards
Aman Kumar

View solution in original post

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Cheski Frank 

Did you try this?

This should also work fine.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

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

Aman Kumar S
Kilo Patron

Hey,

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

 

Best Regards
Aman Kumar