Instruction to Change Worklog owner under All Request, worklog owner From Tech A to Tech B

Instruction to Change Worklog owner under All Request, worklog owner From Tech A to Tech B

    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. 

          • Related Articles

          • Steps to Change Report Owner

            Kindly follow the below instruction to change the report owner. ( From Tech A  to Tech B) Query to get Technician User ID:     SELECT * FROM AAAUSER WHERE FIRST_NAME LIKE '%TECH NAME%'; You may replace the Tech A name and Tech B name to get the user ...
          • Request aging with recent worklog comments

            MSSQL: 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 "Subject",wodm.Dependsonid ...
          • Query to show both task comments and worklog comments

            MSSQL: 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 "Owner", "taskdet"."TITLE" ...
          • Query to show Last added worklog of a ticket _MSSQL

            MSSQL: SELECT wo.WORKORDERID AS "Ticket Number", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", aau.FIRST_NAME AS "Requester", Wo.title "Subject", wotodesc.FULLDESCRIPTION AS ...
          • Query to show Change Roles in change requests

            MSSQL: SELECT "chdt"."CHANGEID" AS "Change ID", "chdt"."TITLE" AS "Title", LONGTODATE("chdt"."CREATEDTIME") AS "Created Time", LONGTODATE("chdt"."SCHEDULEDSTARTTIME") AS "Scheduled Start Time", LONGTODATE("chdt"."SCHEDULEDENDTIME") AS "Scheduled ...