Adding report summary in email content when creating schedule report

[VickieT]

I've created a list report to show the long pending incidents and scheduled it to send to CIO and senior management weekly. Some time there would have no pending incidents in the report, instead of omit when no record, he would like to add a ticket count in the Email content to let him know if he need to open the attached Excel file. May I know if anyone has such experience to deploy it?

[Ankur Bawiskar]

@VickieT 

you can use email body in scheduled report

Embed List Reports in a Scheduled Report Email 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@VickieT 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ahmmed Ali]

Hello @VickieT 

You can create an email script to query the table with same condition as your report and print the data in the email body.

you can refer below link for more details:

https://developer.servicenow.com/dev.do#!/learn/learning-plans/xanadu/new_to_servicenow/app_store_le... 

Thank you,

Ali

[Dr Atul G- LNG]

Hi @VickieT 

I think @Ahmmed Ali's answer is still valid. Instead of sharing the entire data via email, the focus should be more on educating users and improving day-to-day operations. Writing a large piece of code just to avoid a single click could potentially increase technical debt.