Generate mail if the Incident tickets are not been updated more than one day

[AmadasaniS]

We have a requirement where we need to identify Incident records in the Incident table that have not been updated for more than 2 day . The details of these incidents — including Number, State, Category, and Last Updated Date — should be compiled and sent in a single email.

Could someone please guide us on how to implement this solution in ServiceNow?

[Mdsaqib826 · Accepted solution]

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

[Bhuvan · Accepted solution]

@AmadasaniS 

You can schedule a report to be triggered daily and sent to client stakeholders automatically. For your requirement, I already shared how you can create a report and consolidate it and send it as attachment. If there are no records for that day, you can also skip using 'Omit if no records' option.

In my opinion, for your requirement this is the best option rather than Flow Designer as this can be catered via reports and dashboards without any additional development. You can test it in PDI or Non-Production instance and decide which option you prefer.

Please see below for PA Dashboards and Schedule option

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[SajidK]

Thank you for sharing this information that’s what i was looking for 

warn regards 

sajidkhan,

[PranayN]

Very helpful