Including Record Count in Scheduled Report Email

[BibekP]

Hello Team,

I have created and scheduled a report. I would like to include the number of records in the email body. Could you please advise on how to achieve this?

[Dr Atul G- LNG]

Hi @BibekP 

https://www.servicenow.com/community/performance-analytics-forum/how-to-add-number-of-cis-count-in-e...

https://www.servicenow.com/community/performance-analytics-forum/how-to-add-number-of-cis-count-in-e...

[priyatam_pvp · Accepted solution]

ServiceNow’s Scheduled Reports do not natively provide a way to include a record count in the email body, you can achieve this using the below code in the mail script change table name and filters:

Mail script :

var gr = new GlideAggregate('incident'); // Change table name as needed

gr.addQuery('active', true); // Apply your conditions

gr.addAggregate('COUNT');

gr.query();

var recordCount = 0;

if (gr.next()) {

    recordCount = gr.getAggregate('COUNT');

}

Please Mark this helpful

Regards
Priyatam

[Ankur Bawiskar]

@BibekP 

you can use email script in scheduled email body and print the record count based on your report filter conditions

Scheduling a report with an inline table in mail body with the attachments 

Embed List Reports in a Scheduled Report Email 

Scheduling a report for dynamic Recipients based on the table column of the report 

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

[Shivalika]

Hello @BibekP 

Last I tried, score based report was not generating any attachment in the email that was scheduled. 

So it's better to go via script and show the count in the email body. Mail script would work in this scenario definitely. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY