Script to send reminder emails to requester when there is no response from them for more than a specified time period
Use case:
Reminder emails should be triggered to requester when the request is moved to a custom status and left unattended for more than a said time.
For eg., In this case, three reminder mails will be sent to the requester in different time intervals after the request status change.
First reminder mail will be sent when its 3 day past the request update. Second mail will be sent when its 5 days, and final reminder will be sent when its 7 days past the last request update. After which the ticket will be automatically closed.
Prerequisites:
1. Python Installation Steps : https://pitstop.manageengine.com/portal/kb/articles/how-to-setup-python-on-the-server
2. functions.py : This package consists of all the functions that are used to handle the standard requirements of the customer. Most repeated requirements are written as separate functions. Depending on our usecase, we can include these functions in our script.
3. configuration.json : This file maintains the configuration details of the installed server.
Execution steps:
1. Execute the below query and save the report with a title.
select workorder.helpdeskid "portalid", workorder.workorderid "workorderid", workorder.title "subject", aaacontactinfo.emailid "emailid", workorderstates.last_tech_update "last_tech_update" from workorder
inner join workorderstates on workorder.workorderid=workorderstates.workorderid
inner join statusdefinition on workorderstates.statusid=statusdefinition.statusid
inner join aaauser on workorder.requesterid=aaauser.user_id
inner join aaausercontactinfo on aaauser.user_id=aaausercontactinfo.user_id
inner join aaacontactinfo on aaausercontactinfo.contactinfo_id=aaacontactinfo.contactinfo_id
where statusdefinition.statusname='waiting for user reply'
2. Extract the ZIP file under ..\ManageEngine\Servicedesk\integration\custom_scripts - folder.
3. Edit the configuration.json and update the values.
4. Configure a custom schedule to execute everyday and pass this report as a parameter.
5. Go to Admin > Custom Schedule > give a schedule name > execute script > py send_reminder.py
Query Report:
Custom Schedule:
New to ADSelfService Plus?
Related Articles
Time taken to First Response
First Response Time is the number of minutes, hours, or days between when a customer submits a support ticket and when a customer support representative provides an initial response. It indicates how long a customer has to wait before being helped. ...How to send periodic notifications to requester(s) about their pending requests and accordingly update their status.
This post describes the use of a python script to notify requester(s) about their requests through email and move those to a specific status. Use Case: Let us assume a scenario where the technicians reply to a request and put it in a custom status ...Update Requester from Request Description
Usecase: When a request is submitted on behalf of a user via email, the request description includes the requester's full name. This must be parsed in order to update the ticket requester. Steps to follow: Goto Admin > Request Custom Functions > ...Reminder Emails and Notifications for Pending Approvals: Ensuring Timely Actions
Requirement: If the approver does not act on an approval, three reminder emails should be issued. Even after issuing reminders, if they do not approve the requests, an email notification should be issued to the Approver's Reporting Manager. Steps to ...FAFR script to populate drop down list of emailIds to notify for the requester.
Requirement: Populate "Email Ids to Notify" field dropdown for requester login. Steps to follow: 1. Goto the required request template >> Field and form rules > On Form Load 2. Paste the attached script content and save it with a name. var ...