How to send notification mail to the Reporting Manager when a SLA is breached ?
Use Case:
When a SLA is getting breached, the technician's "ReportingTo" Manager has to be notified over email.
Prerequisites:
1. Python Installation Steps : https://support.servicedeskplus.com/portal/kb/articles/setting-up-the-application-server-to-run-python-scripts
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. Extract the attached SLA_BreachNotification.zip file under ..\ManageEngine\Servicedesk\integration\custom_scripts - folder. All files should be present under custom_scripts folder (Refer placing.png)
2. Edit the configuration.json and update your mail configuration details and administrator technician key. You can generate the API Key from Personalize in the top right of the user interface.
3. Login to the application and goto Reports -> New Query -> Execute the below query and save the report with a name.
select sduser.userid, sduser.reportingto, aaacontactinfo.emailid from sduser
inner join aaausercontactinfo on aaausercontactinfo.user_id=sduser.reportingto
inner join aaacontactinfo on aaacontactinfo.contactinfo_id=aaausercontactinfo.contactinfo_id;
4. Goto Admin -> General -> Custom Schedules
- Configure a Custom Schedule with the above report as the Arguments.
- In the Executor -> Provide py readJsonFromFile_Reportingto.py
- Start Date & Time --> Give the time to execute it in few minutes.
- Repeat -> None. (Means it will run only once)
(Refer - custom-schedules snapshot attached)
On completion of the schedule a reportingTo json file will be created in the custom script folder (This json is used to get the mail id of the reporting to user) . wait till you see the message Executed Successfully in the custom schedule page.
5. Now create a SLA and define action such that on SLA escalation set level as Tier4. (Refer SLA action)
6. Add a business rule with criteria as level is Tier 4, and action as Execute Script "py send_mail_reportingto.py $COMPLETE_V3_JSON_FILE" (place the value without quotes). (Refer BR action)
Now when the SLA response time is reached and the Level is set through the actions, then the control will go to the Business Rules and the trigger will get executed. ie mail will sent to the ticket owner's Reporting to Manager which is configured in the technicians page.
New to ADSelfService Plus?
Related Articles
Send escalation email to the Technician "Reporting to" if SLA is violated (Deluge).
From Builds 10600 and above Follow the below steps and based on the update we need to create a custom trigger based on the action set under the SLA escalation notification and then with the help of that we can execute the custom trigger and the ...Notification script using Custom function in custom trigger
This is applicable from 10600 builds. From 10600 , Business rules dont have Email notification feature. The same use case be achieved through Custom triggers feature as mentioned below. Script to enable notification of request creation using custom ...How to send SLA notification mail to the different users when a SLA is breached for builds 10500 and above
We can use the Email feature in the custom triggers to send notifications to different roles configured in SDP-MSP. By default, the SLA notification can be sent to Account Managers, Point of Contact, Technician, Requester. If you would like to send ...How to send custom email notifications for a request_NOT IN USE
This sample python script is used for sending custom notifications from ServiceDesk Plus MSP when a criteria is met. You all know that ServiceDesk Plus MSP has notification rules and customisable templates to notify requesters, technicians, and ...Script to send notification to users on upcoming contracts
Please follow the below link to setup python on the server https://pitstop.manageengine.com/portal/en/kb/articles/how-to-setup-python-on-the-server-11-11-2019 Steps to configure 1. Extract the attached zip file in <Home>/integration/custom_scripts ...