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 "workorderid", chargestable.chargeid "chargeid", aaauser.first_name "name" from workorder
Left join workordertocharge on workorder.workorderid=workordertocharge.workorderid
Left join chargestable on workordertocharge.chargeid=chargestable.chargeid
Left join aaauser on aaauser.user_id=chargestable.technicianid
where aaauser.first_name ='update duplicate worklog owner name'
Above query will list all worklog which is assigned to duplicate user.
Save the Report as Incorrect worklog Owner
Step 2 :
Download the attached python script and place it under ServiceDeskPlus-MSP\integration\custom_scripts
Edit the python script and update the highlighted fields.
* Application URL
* API key of Admin User (Technician with SDAdmin Role)
* Actual Technician name which needs to be replaced in place of duplicate worklog owner
Step 3
Navigate to Admin - > Custom schedules and create a new schedule as shown below.
Executor - Will the python script which will update the worklog owner
Arguments - The Report which gets lists of worklog which are assigned to incorrect Technician
Schedule - Choose a time frame for schedule to execute and change the worklog owner.
Note: We strongly recommend you to take a backup before trying above steps.
You may test the configuration on Test setup before trying on Production Setup.
New to ADSelfService Plus?
Related Articles
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 ...Option to cancel the pending tasks when Request is cancelled- when the worklog is mandatory
Requirement: Customer needs to close the tasks when the request is closed and the worklog is mandatory field in request closing rules. Download the attached scripts. Under Admin > Developer Space > Global Custom Function, create a new custom ...Request aging with recent worklog comments (MSSQL)
Tested in MSSQL build (14306) SELECT wo.WORKORDERID AS "Request ID", CASE WHEN (wo.is_catalog_template) = 'false' THEN 'Incident' ELSE 'Service Request' END "Request Type",dpt.DEPTNAME AS "Department",pd.PRIORITYNAME AS "Priority", wo.TITLE AS ...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 ...Query to show both task comments and worklog comments ( MSSQL )
Tested in MSSQL build (14306) SELECT "taskdet"."TASKID" AS "Task ID", "taskdet"."TASKID" AS "Task ID", "wotask"."WORKORDERID" AS "RequestID", cd.CATEGORYNAME AS "Request Category", "taskgroup"."QUEUENAME" AS "Group", "taskowner"."FIRST_NAME" AS ...