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