Parse a list of records in ServiceNow into a single Notification HTML

[Anish Reghu]

How can we parse a list of records into the Message HTML field that we see on the notification? Should we be using an email script for this?

For example, the ask is to:

a) Read the list of Active incidents, still unassigned this month.

b) Parse all relevant information in a tabular format into the Message HTML field on the Notification

• Let's assume, I need Number, Short description, Priority and State in the email to be triggered.
• All these information must be in a tabular format, when viewed by the targeted recipient.

How to achieve this?

If a solution could be posted, that would be extremely helpful.

Many thanks in advance,

Anish Reghu

[Najmuddin Mohd · Accepted solution]

Hi @Anish Reghu ,

You can just use Scheduled reports using the filter conditions and email the Users that you need, which will be in tabular format.

Regards,
Najmuddin.

[Luiz Lucena]

Adding more info to what Najmuddin suggested, you can schedule the report to be sent with an Excel spreadsheet with the list of incidents.

[Anish Reghu]

@Luiz Lucena - Thanks, I was trying to stack the list view of incidents grouped by 'Assignment group', by Category as well. I tried Additional group by, but that's not what I am looking at. I want an embedded grouping of records on the report view.

How to achieve that?

Regards,

Anish

[Anish Reghu]

Thank you both, although I had seen this Scheduled Reports had not realized it's importance, until I was redirected to it, as part of this use case.

Regards,

Anish