Send Auto reminders to Change Approvers after X days
Here is the script and kindly follow the steps below to achieve your requirement to send Auto reminders to Change Approvers after X days. For now, the script sends reminder for every 24 and 48 hours. This can be customized in the script.
1.Download the contents and paste it under \ManageEngine\ServiceDeskPlus-MSP\integrations\Custom_scripts folder.
2.Execute the below Query under Reports->New Query tab and save the query.
select changestatuscomments.changeid "workorderid", aaacontactinfo.emailid "emailid", changestatuscomments.commentedon "last_tech_update" from changestatuscomments inner join changedetails on changestatuscomments.changeid = changedetails.changeid inner join changeroleusermapping on (changeroleusermapping.changeid = changedetails.changeid) inner join aaausercontactinfo on (changeroleusermapping.userid = aaausercontactinfo.user_id) inner join aaacontactinfo on (aaausercontactinfo.contactinfo_id = aaacontactinfo.contactinfo_id) where changestatuscomments.wfstageid =(select wfstageid from change_stagedefinition where name like '%planning%') and changestatuscomments.wfstatusid =(select wfstatusid from change_statusdefinition where statusname like '%approved%' and wfstageid =(select wfstageid from change_stagedefinition where name like '%planning%')) and changedetails.appr_statusid =(select statusid from approvalstatusdefinition where statusname like '%pending%' ) and aaacontactinfo.emailid is not null and changeroleusermapping.roleid=(select id from changeroles where name='ChangeApprover');
3.Configure Custom Schedule for every one hour. So, query will run for every 1 hour and check if there is any approver to be reminded. 1 hour is the minimum, so reminder will be sent 24 + 1 Hour maximum.
New to ADSelfService Plus?
Related Articles
Script to send reminder mail to the users who haven't logged into the application for the last X days.
Please follow the below steps to send mail to the users who haven't logged in for the last X days: Step 1: Navigate to Reports--->New Query Report--->Execute the given query--->Now the report will be generated. Step 2: Save the report with a name ...Change Auto closure
This will be helpful in auto closing change request after X days it is in review stage. This use case is more suitable in environments where ONLY Requesters (customers) are the Change Reviewers and they want the Change to be closed if no review is ...Script to Auto close Request when the status is Resolved for a particular number of days
For version 11 and above: -> In version 11, we only have the option to set the request Auto-close for a max of 10 days -> The below script will help you to extend the auto-closure time Execution steps: 1. Go to Reports--> New Query Report and run the ...Script to send reminder emails to requester when there is no response from them for more than a specified time period
There are scenarios where if the end-user is not responding for a specified period of time they need to be reminded of the same. This can be achieved using a script. Use case: Reminder emails should be triggered to requester when the request is ...To send an acknowledgement email notifications to change owner for every reply conversation in change.
Overview The below document explains the steps that need to be configured for sending notifications to change owner for every reply conversation in changes. (i.e) When a reply is sent and a conversation is added to a change then the acknowledgment ...