question Re: Generate mail if the Incident tickets are not been updated more than one day in Virtual Agent forum

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

AmadasaniS — Wed, 17 Sep 2025 07:42:25 GMT

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?

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

J Siva — Thu, 18 Sep 2025 07:50:22 GMT

HI @AmadasaniS
Either use Flow designer (Run daily trigger) or Scheduled Job to check the last updated date. If it's not updated in last 24 hours, then send an email notifictaion.
Try this and let us know if you stuck in the middle..
Regards,
Siva

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

Sanjay191 — Thu, 18 Sep 2025 07:54:26 GMT

Hello @AmadasaniS

Please refer the below flow designer i hope this should work for this

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thank You!!

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

Bhuvan — Thu, 18 Sep 2025 08:11:33 GMT

@AmadasaniS

I would recommend to create a report or data visualization in PA Dashboard with dynamic conditions where you can check status is New or In Progress and Updated is 2 days older than today and send email notifications to client stakeholders

Below is for sample

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

Thanks,

Bhuvan

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

Mdsaqib826 — Thu, 18 Sep 2025 08:18:24 GMT

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

Navigate to Flow Designer in the left-hand navigation pane.
Click New > Flow.
Give the Flow a descriptive name (e.g., Daily_Unchanged_Record_Notification).
Click Submit.

Step 2: Add a Trigger

Click Add a Trigger.
Select Date as the trigger type.
Set the Run field to Daily.
Choose the desired Time to run the check (e.g., 07:00:00 for 7 AM).
Set the Time zone to System.

Step 3: Add an Action to Look Up Records

Click the plus icon (+) below the trigger and select Action.
Select the ServiceNow core action type.
Choose Look Up Records.
Specify the Table you want to check (e.g., incident).
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

Click the plus icon (+) below the Look Up Records action and select Flow Logic.
Choose For Each.
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

Inside the For Each loop, click the plus icon (+) and select Action.
Select the ServiceNow core action type.
Choose Send Email.
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

Click Save in the top-right corner.
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

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

AmadasaniS — Thu, 18 Sep 2025 08:29:06 GMT

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.

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

AmadasaniS — Thu, 18 Sep 2025 08:31:04 GMT

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.

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

Bhuvan — Thu, 18 Sep 2025 08:43:46 GMT

@AmadasaniS

Did you get a chance to review this as I believe the information provided should answer your question and would be the most simple way to fulfil your requirements.

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

Thanks,

Bhuvan

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

AmadasaniS — Thu, 18 Sep 2025 08:58:12 GMT

Hi Bhuvan, thanks for the suggestion. In our case, the system should automatically check daily for incident tickets assigned to a specific group that haven't been updated for more than a day, and send a single consolidated email to the group — ITservice_desk@gmail.com.

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

Bhuvan — Thu, 18 Sep 2025 14:45:28 GMT

@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

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

SajidK — Thu, 18 Sep 2025 14:49:56 GMT

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

warn regards

sajidkhan,

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

PranayN — Thu, 18 Sep 2025 18:12:32 GMT

Very helpful

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

Bhuvan — Fri, 19 Sep 2025 05:50:12 GMT

@AmadasaniS

Did you get a chance to review this ?

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

Thanks,

Bhuvan

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

AmadasaniS — Fri, 19 Sep 2025 06:35:22 GMT

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.

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

AmadasaniS — Fri, 19 Sep 2025 06:37:42 GMT

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.

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

AmadasaniS — Fri, 19 Sep 2025 12:22:19 GMT

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

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

Bhuvan — Fri, 19 Sep 2025 15:56:50 GMT

@AmadasaniS

I would recommend you to schedule data visualization report as per your requirements and it can send list in PDF format. It can also be done via dashboards or reports, see which suits you the best.

See below for sample

If this suits, go to Platform Analytics -> Library -> Data Visualization and add data source and configure list visualization along with filter conditions. Columns shown will be default list view of data source table, you can change default list view and it will reflect in data visualization. Also, you can over-ride by adding required columns under Presentation -> Columns and Rows -> Add required Columns

Go to more actions -> Schedule and share the report in PDF format with required stakeholders. This is a standard format to share the reports and should cater your requirements. I would recommend not to customize much as this fulfills functional requirements.

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

Thanks,

Bhuvan