Weekly status report as a email notification

[Sonali Jadhav]

Send e-mail notification of Weekly status report to relevant stakeholders ?

and can we Send e-mail notification on major updates to relevant stakeholders

major updates like Overdue milestone date etc.

[Harsh Vardhan]

you can schedule your report and then add respective user to receive it on there email. 

Kindly have a look on below doc link. 

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/reference-pages/t...

[Sonali Jadhav]

But I want to send e-mail notification of Weekly status report to relevant stakeholders.

every project have different project manager or portfolio manager so how we are going to add respective user every time?

[Harsh Vardhan]

did you create report ? if yes then i am assuming here you are using project_status table on your report. 

Please try with below steps.

• I am assuming you have already Created one report , if not please create it.

• Now create here on Scheduled job ( which will run daily or weekly based on your need) to get the list of project manager, here you will do glide record on your project table to get those manager . now in scheduled job you will use gs.eventQueue() to trigger your notification 

http://techcommunity.softwareag.com/pwiki/-/wiki/Main/ServiceNow%20Email%20Notification%20via%20Even...

• You will create here event based notification and use the event to trigger your notification. now in your notification you will pass your report sysid so whenever notification will get trigger those respective manager will get as excel/pdf attachment. refer below hi article.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0596145

[Sonali Jadhav]

Hello Harshvardhan,

We have a requirement where we want to send a project status report(you can see project status report by clicking related link 'project status report') weekly basis of a projects to its relevant project stakeholders.

How we can achieve this?