How to close associated incident requests of change request automatically
This post describes the use of a python script to close change that are in a specific stage using Custom Schedules.
There may be a scenario where number of Change Requests that have got closed and the associated incident is still in open status.
1. Go to Reports--> New Query Report and run the below query and save this report.
SELECT chdt.CHANGEID "changeid", wo.WORKORDERID "workorderid" FROM ChangeDetails chdt
LEFT JOIN Change_StatusDefinition statusDef ON chdt.WFSTATUSID=statusDef.WFSTATUSID
INNER JOIN IncidentToChangeMapping icm ON chdt.CHANGEID=icm.CHANGEID
LEFT JOIN WorkOrder wo ON icm.WORKORDERID=wo.WORKORDERID
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID where std.ispending='1' and statusDef.STATUSDISPLAYNAME = 'completed'
This will give you the ID of requests associated to change request which is completed. Please update the query based on your requirements.
2. Downloaded the attached Zip file and move the files to ManageEngine/ ServiceDesk/ integration/custom_scripts folder
3. Edit configuration.json file and update the application URL and the Technician Key
4. Configure the schedule under Admin--> Custom Schedule
I've attached a screenshot showing a sample implementation below.
ReplyReply AllForwardEdit as new
New to ADSelfService Plus?
Automatically close request after successive approval reminders.
This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...
Close all the associated requests when a change is closed
Requirement: When a change is closed, all the associated requests have to be closed. This includes both: Change initiated due to request Request caused by change Steps to configure: Goto Admin > Developer Space > Global function > New > Paste the ...
Close change requests using custom schedules.
This post describes the use of a python script to close change that are in a specific stage using Custom Schedules. Use Case: There may be a scenario where number of old Change Requests that have gotten lost in the shuffle over the years. Most of ...
How to automatically create a task in a Change Request.
This is a sample script to create a task in a Change Request based on the values given in certain fields. This is done by using an API call to create a task in ServiceDesk Plus. The task can also be created in a request, problem, project or a ...
How to close linked requests when a parent request is closed.
This post describes the use of a python script to close all the linked request when a parent request is closed using custom triggers. Use Case: We get tickets which are getting reported for the same issue but different end-users so that once we ...