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]

If i am not wrong, you are talking about below layout in your report as pdf format in your notification ?

OOTB pdf generation will not give you this layout.

this is coming from portal page "project_status_report". 

you can get the data from project_status table and create a report. 

You can check below thread as an example. 

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

[Sonali Jadhav]

Yes this project status report we are looking for. can we send link of this status report to project stakeholders as a email notifications weekly basis but user don't want to login to the instance while opening that link form notification can we do this ?

[Harsh Vardhan]

Lots of effort you have to put if you want to include this page as URL in your notification.

eg:

Steps:-

• You have to set public as true on "project_status_report" page. because this is portal page and user can see it without login into the instance , also you have to set public true on widget which has used in "project_status_report" portal page. 
• Second you have to build an URL using email script where you will pass the project_status record sys_id, once you will pass it then you will able to see the details over the page. 

URL would be something like below. 

https://<Instnace ID>.service-now.com/sp?id=project_status_report&sysparm_report_id=sys id of project status record

Note: I have not tested it, so please try at your instance.