How to retrieve Tasks created by Deleted Tech in Web help desk

Web Help Desk uses tasks to create tickets. A task contains one or more task elements, and each task element provides settings for a new ticket. When the task runs, Web Help Desk creates a ticket for each task element, either sequentially or all at once, depending on the configured task.

In this scenario, the tech who created the tasks leaves the company, and his tech account was deleted. All tasks that he created then go missing from the web console. 

Tasks are tied to the account that creates them, ergo deleting a tech account will also remove all tasks associated to the said tech account.

Retrieve the Tasks created by Deleted Tech and transfer the ownership to another tech by modifying it from the Database Table.

a.     Access your Database Server

b.     Find the Table: TECH and navigate to CLIENT_ID Column and check the ID of the deleted tech

c.      Find the Table: TASK

d.      Navigate to CREATED_BY_ID Column and find and compare the ID of the deleted tech

e.     Run an update query to retrieve the Tasks created by Deleted Tech and transfer the ownership to another tech  

    -- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE TASK
SET CREATED_BY_ID = inserttheidofthetechyouwanttotransfertheownership, DELETED = 0
WHERE CREATED_BY_ID = insertidofthedeletedtech;

-- Example:
-- UPDATE TASK
-- SET CREATED_BY_ID = 1, DELETED = 0
-- WHERE CREATED_BY_ID = 9;

Legal Disclaimer
Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.