Tools

Undelete tickets in Web Help Desk

This article describes how to undelete tickets in Web Help Desk through the database

First published date

10/16/2020 7:57 PM

Last published date

10/16/2020 7:57 PM

Overview

Web Help Desk Technicians and Administrators are allowed to delete tickets from the interface.
These tickets are deleted from the interface but are still saved in the database.
Undeleting the tickets need to be done in the database.

Product section

Web Help Desk

Resolution

 
  • Log in to the database server that is used by the Web Help Desk application.
  • If the embedded PostgreSQL database is used, follow the instructions in this article on how to connect and run the SQL queries. How to connect and view the Web Help Desk embedded PostgreSQL database.
  • If MSSQL or MySQL is used, use the appropriate interface to access the database.
 
  • Run the query below to undelete ALL the tickets from the database.  
REM Disclaimer: Scripts are not supported under any SolarWinds support program or service.
REM 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.
REM The risk arising out of the use or performance of the scripts and documentation stays with you. 
REM 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 JOB_TICKET SET DELETED = 0 WHERE DELETED = 1;
  • If you know the ticket number of the ticket/s you want to undelete, use this command.  
REM Disclaimer: Scripts are not supported under any SolarWinds support program or service.
REM 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.
REM The risk arising out of the use or performance of the scripts and documentation stays with you. 
REM 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 JOB_TICKET SET DELETED = 0 WHERE JOB_TICKET_ID = ???;
  •  Where the ??? is the ticket number.