Hi Bhuvan,
I tried the solution you provided. I created a new report using the Incident table with the List type. I added the following filter conditions:

  • Updated: Relative → Before 2 days ago
  • Active: True

Then, I created a Scheduled Email Report using this report and added the group email ID to which the report should be sent. The email was triggered successfully.

However, when I opened the email, the Incident list appears in a document-style format. What we need is a table-style format showing the records in a grid layout.

For reference, I’ll attach a screenshot. Please check and let me know how we can update the format.More than a day incident 1.png

Hi Bhuvan,
I tried the solution you provided. I created a new report using the Incident table with the List type. I added the following filter conditions:

  • Updated: Relative → Before 2 days ago
  • Active: True

Then, I created a Scheduled Email Report using this report and added the group email ID to which the report should be sent. The email was triggered successfully.

However, when I opened the email, the Incident list appears in a document-style format. What we need is a table-style format showing the records in a grid layout.

For reference, I’ll attach a screenshot. Please check and let me know how we can update the formatMore than a day incident  table list.png

Mdsaqib826
Tera Expert

Hi @AmadasaniS 

Flow Designer is the recommended for this task as it's low-code, highly readable, and makes it easy to visualize the business logic. It also offers excellent performance and is the future-forward way to automate processes in ServiceNow.

 

Step 1: Create a new Flow

  1. Navigate to Flow Designer in the left-hand navigation pane.

  2. Click New > Flow.

  3. Give the Flow a descriptive name (e.g., Daily_Unchanged_Record_Notification).

  4. Click Submit.

Step 2: Add a Trigger

  1. Click Add a Trigger.

  2. Select Date as the trigger type.

  3. Set the Run field to Daily.

  4. Choose the desired Time to run the check (e.g., 07:00:00 for 7 AM).

  5. Set the Time zone to System.

Step 3: Add an Action to Look Up Records

  1. Click the plus icon (+) below the trigger and select Action.

  2. Select the ServiceNow core action type.

  3. Choose Look Up Records.

  4. Specify the Table you want to check (e.g., incident).

  5. Add the following condition:

    • Field: Updated

    • Operator: is more than

    • Value: 24 hours ago (This automatically translates to a correct script-based time check).

    • Note: If you need to check for a value that is not updated, you would use is less than or equal to. For example, Updated is less than or equal to 24 hours ago. This depends on your specific business need.

Step 4: Add Flow Logic

  1. Click the plus icon (+) below the Look Up Records action and select Flow Logic.

  2. Choose For Each.

  3. Drag the Records data pill from the Look Up Records action in the data pill picker onto the Loop over field. This tells the flow to iterate over every record found in the previous step.

Step 5: Add an Action to Send an Email

  1. Inside the For Each loop, click the plus icon (+) and select Action.

  2. Select the ServiceNow core action type.

  3. Choose Send Email.

  4. Configure the email:

    • To: You can use a specific email address, or for a dynamic approach, use a data pill from the record you are looping over (e.g., the Assigned to > Email pill).

    • Subject: Provide a clear subject, such as Warning: Record Not Updated in 24 Hours. You can also include data pills like Record: Number to make it specific.

    • Body: Write the email body. You can use data pills to include record details like Record: Number, Record: Short description, and a direct link to the record using the Record: Link data pill.

Step 6: Save and Activate

  1. Click Save in the top-right corner.

  2. Click Activate to make the flow runnable.

Review & Testing: Before activating, you can click Test to run the flow on demand. This is a great way to ensure your Look Up Records query is correct and that the email is sent as expected.

If this helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Mohammad Saqib Khan

View solution in original post

Hi Mdsaqib826, thanks for the solution. I’ve already tried it — it works, but it sends multiple emails for each incident. For example, if there are 10 incidents not updated for more than a day, it triggers 10 separate emails. Instead, I need all these incident records to be included in one single email sent to the group.

Hi

Mohammad Saqib Khan , thanks for the solution. I’ve already tried it — it works, but it sends multiple emails for each incident. For example, if there are 10 incidents not updated for more than a day, it triggers 10 separate emails. Instead, I need all these incident records to be included in one single email sent to the group.