Change Request->Planned End Date Passed ->Trigger Notification to the Assignment Group

[Lakshmi Prabha]

A change Requested is created and assigned to a Group. After Approval, Assignment group member implements the change in PROD. But they are not closing the Change request after implementing in PROD. Change Manager could see lots of change requests are not closed in PROD even if Planned End date is passed.

Customer requirement is to create daily scheduled report/email notification to Assignment group/Assignee if Planned End date is passed for Active CR's(Not Closed).

Eg:

Planned Start date : 06/04/16

Planned End date: 06/05/16

Assignment Group : Server Team

Assigned to : Server Team member

Today's Date :   06/06/16

Current CR state: Ready to Implement

Active: True

Note: The above CR has been implemented yesterday. But assigned to person didn't change the state to Closed.

Is there a way to generate Notification to the assignment group in the above scenario?   There were more than 50 Assignment groups available in Change request. Don't want to create 50 separate schedule report for this scenario. Do we have any other option to achieve this?

[Pradeep Sharma]

Hi Lakshmi,

Create a daily scheduled job that queries the change_request table as per your logic and then trigger the event to fire email notification.

Creating a Scheduled Job - ServiceNow Wiki

http://wiki.servicenow.com/index.php?title=Events_and_Email_Notification

Fire an email notification from a schedule job

[Goran WitchDoc · Accepted solution]

Agree with Pradeep,

I have just written an example here how to do the "scheduled job->email thingie".

You can read about it here: Fire an email notification from a schedule job

//Göran

[Eric K3]

When I try to set a filter on the Change Request table for Planned end date relative on or before 1 minute ago and click Run, nothing happens.

How would I set the condition so that checks for all change requests where the planned end date is before the current date/time?