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 Query Reports.
Create a new custom schedule with a unique Schedule Name. Mention the command to execute the script in the Executor field. Associate the required Query Reports as Arguments. Mention the Start Date & Time when the action should take place. Schedule the action by specifying the Repeat interval. Enable/Disable a custom schedule as preferred.
Pre-Requisites
1. Python should be installed in the server with the Request package. You can find the instructions here.
Steps
1. Download the attachment and place it under ManageEngine\ServiceDeskPlus-MSP\integration\custom_scripts
2. Edit addWorklog.py and update the URL, technician key.
3. Under Reports Tab >> New Query Report >> Run the below query >> Save the report
SELECT "wo"."WORKORDERID" AS "Request ID", "ad"."ORG_NAME" AS "Account", "sdo"."NAME" AS "Site", "ac"."CONTRACTNAME" AS "Contract Name" FROM "WorkOrder" "wo" LEFT JOIN "SiteDefinition" "siteDef" ON "wo"."SITEID"="siteDef"."SITEID" LEFT JOIN "SDOrganization" "sdo" ON "siteDef"."SITEID"="sdo"."ORG_ID" LEFT JOIN "AccountSiteMapping" "asm" ON "wo"."SITEID"="asm"."SITEID" LEFT JOIN "AccountDefinition" "ad" ON "asm"."ACCOUNTID"="ad"."ORG_ID" INNER JOIN "WorkorderToContract" "wtc" ON "wo"."WORKORDERID"="wtc"."WORKORDERID" LEFT JOIN "AccountContract" "ac" ON "wtc"."CONTRACTID"="ac"."CONTRACTID" INNER JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" WHERE (wo.ISPARENT='1') and sdo. wo.workorderid in (64,63)
The above query will filter the request based on the id provided which also has an active contract. The work logs will also be added to the same tickets.
4. Under Admin >> Custom Schedule >> Create a new schedule to run >> The report needs to be added as arguments.
New to ADSelfService Plus?
Related Articles
How to auto-create worklog based on values specified in the request
This post will to help you create a worklog automatically when a request is created. This script can be configured under Request custom triggers and you will find more information about this here. This is achieved using an API call to create a ...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 ...Instruction to Change Worklog owner under All Request, worklog owner From Tech A to Tech B
Scenario Worklogs assigned to Duplicate user / Incorrect user need to change all worklogs under request to actual Technician. Step 1 : Navigate to Report - > New Query Report and execute the below query. Select workorder.workorderid ...Script to Disable Worklog Addition on Closed Request
Kindly use the below scripts under Admin -> Page Scripts to disable Worklog addition on Closed request. The below script hides the Save option while creating new worklog on closed request. Script: let params=new ...How to update Request Additional fields during request create/update using Custom Triggers (V3)
This is a sample python script to update the Request Additional Field Values during request create/update based on certain criteria using Custom Trigger Execution Steps: 1. Download the attached zip 2. Move the files to ...