I need a weekly report for open change tasks with expired Planned End Dates

[Saurav Bhardwa2]

Hello,

I need a weekly report for open change tasks with expired Planned End Dates. It should cover tasks from the past week.

Let's say, there is a change request and it has 3 change task with date 10/1/2023. I wanted to pull out all the open change task from date 10/1/23 to 10/7/23 that has expired planned end date. Can we make it dynamic so from next week it will auto-pick the next week. I wanted to send scheduled reports to all group Managers who has the change_task opened.

Is this possible with OOB or do I need to create something custom for this?

[Riya Verma]

Hi @Saurav Bhardwa2 ,

Hope you are doing great.

To achieve this, you can use ServiceNow's Scheduled Reports along with a custom script to dynamically calculate the date range. Here's a high-level solution:

1. Scheduled Report Configuration:

   • Set up a scheduled report in ServiceNow to run weekly.
   • Configure the report to fetch open change tasks with an expired planned end date.
   • Define the report parameters to include the necessary fields (such as Task ID, Planned End Date, etc.).

2. Custom Script for Dynamic Date Range:

   • Write a background script that runs before the report is generated. This script will calculate the date range for the past week.
   • This script should dynamically generate the start and end dates based on the current date.
   • For example, if today is 10/8/2023, the script should generate the date range from 10/1/2023 to 10/7/2023.

3. Sending Reports to Group Managers:

   • Set up a notification mechanism in ServiceNow to send the report to the group managers.
   • You can use workflows and notifications to automate this process.

4. OOB vs Custom Solution:

   • While some parts of this solution can be achieved out-of-the-box (scheduled reports, notifications), the dynamic date range calculation will likely require a custom script.
   • The custom script ensures that the date range always covers the past week.

[AndersBGS]

Hi @Saurav Bhardwa2 ,

Not quite understand your question. Do you want the change tasks that will expires this week according to your example? Or do you want change task that has expired last week? And the planned end date - should that be from the change request or from the change task itself.

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

best regards

Anders