Help with Scripting/Conditional for Scheduled Report Emails

[Sean Quinn]

Hi All,

I have been doing reports for my team for the past year, I have the Reporting Admin Role but not a general Admin role.

I am trying to have or Scheduled Reports sent from my email address as opposed to the standard Do-Not-Reply ServiceNow address. I understand I need an Admin Role to change this, so I have been trying to use a script to insert into the conditional field within the scheduled jobs.

Is there a way to do this? I have been able to write a code to send reports on weekdays and skip the weekends, but I am unable to get the sender address changed using a script. Below is the point where I have given up, after weeks of trying to get it correct. Any help will be appreciated.

[ARG645]

Sean Quinn,

There is NO way for sending emails from ServiceNow through a user-defined email address. Every email that goes out of ServiceNow will go out through the Outbound Mail Server [SMTP] which represents a unique email address [Do-Not-Reply thing]. 

Please mark the answer as Helpful/Correct If applicable.

Thank you,

Aman Gurram

[Sean Quinn]

Thank you for your response Aman, I have come across multiple threads regarding the same issue such as the link below details, I just cannot call the script. I have updated my script but I still have issues. Is it completely impossible??

https://community.servicenow.com/community?id=community_question&sys_id=3d5b8721db9cdbc01dcaf3231f96...

I do call the [sys_email]  in the body of the report.

[ARG645]

May I know what table you are on? Is this a scheduled report? 

[Sean Quinn]

This is a Scheduled Report yes, are you referring to the Fact's Table? which is sys_email.

Sorry we are all new to servicenow