Send notification based on custom date additional field using Python Script
1.Download the contents and paste it under \ManageEngine\ServiceDeskPlus-MSP\integrations\Custom_scripts.
Note: I have specified wof.UDF_DATE1 as an example. You can check the exact name of the Column under Admin --> Incident Additional Fields
4. Go to Admin --> Custom Schedules and create a schedule by selecting the report and specifying the script like below:
https://help.servicedeskplus.com/configurations/general/custom_schedules.html
2.Go
to Reports tab --> New query report --> copy the query to the
query editor and run the report. Save the report in the folder.
SELECT
wo.WORKORDERID AS "workorderid", wo.TITLE AS "subject", aau.FIRST_NAME
AS "requester",(AaaContactInfo.EMAILID) "emailid",wof.UDF_DATE1 AS
"vendor_collectiondate" FROM WorkOrder wo LEFT JOIN WorkOrder_Fields wof
ON wo.WORKORDERID=wof.WORKORDERID
INNER JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN AaaUserContactInfo ON aau.USER_ID=AaaUserContactInfo.USER_ID
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID
left join statusdefinition std on wos.statusid=std.statusid WHERE (wo.ISPARENT='1') and std.ispending='1' and
extract(epoch from( to_timestamp(wof.UDF_DATE1/1000)::TIMESTAMP - now()::TIMESTAMP))/3600/24 = 0
The above query is for Postgres Database. If you're using MSSQL, please use the below query:
SELECT
wo.WORKORDERID AS "workorderid", wo.TITLE AS "subject", aau.FIRST_NAME
AS "requester",(AaaContactInfo.EMAILID)
"emailid",longtodate(wof.UDF_DATE1) AS "vendor_collectiondate" FROM
WorkOrder wo LEFT JOIN WorkOrder_Fields wof ON
wo.WORKORDERID=wof.WORKORDERID INNER JOIN WorkOrderStates wos ON
wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser sdu ON
wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON
sdu.USERID=aau.USER_ID LEFT JOIN AaaUserContactInfo ON
aau.USER_ID=AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo ON
AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID left
join statusdefinition std on wos.statusid=std.statusid WHERE
(wo.ISPARENT='1') and std.ispending='1' and DATEDIFF(day, dateadd(s,datediff(s,GETUTCDATE(),getdate())+(wof.UDF_DATE1/1000),'1970-01-01 00:00:00'),GETDATE()) =0
3. In the configuration.json, configure the outgoing mail server settings , url and technician key.
Note:
Verify the query before scheduling. It should list the requests for the date additional fields that are same as today's date.
A short guide on setting up python is available here :
Refer to the link below in order to setup the custom schedule:
New to ADSelfService Plus?
Related Articles
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 ...Script to Update Date additional field (to 3 days) based on priority inside the request
In some cases the customer will need to update the date additional field based on priority set inside the request. (Applicable for builds 14300 & above) Please follow the below mentioned steps to configure: First Download and extract the attached zip ...Script(Deluge) to send approvals based on the Picklist value selected in additional field.
From Builds: 10605 Please follow the steps below on how to configure and send approvals based on the values selected in Picklist of Additional field. 1: Download the attached zip file. 2: Navigate to Admin>>Incident/Service catalog additional field ...Script to add worklog using custom schedule
What is a Custom Schedule? Custom Schedules are actions scheduled on a specific date and time with or without repeat frequency. The actions are specified in a customized script file. Any data from ServiceDesk Plus can be sent to the script through ...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 ...