Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Restore a deleted Request Type or Problem Type from an embedded PostgreSQL database

Restore a deleted Request Type or Problem Type from an embedded PostgreSQL database

Table of contents

Overview

This article describes how to restore a deleted Request Type (Problem Type) from an embedded PostgreSQL database. 

Environment

All WHD versions

Steps

If you are using the embedded PostgreSQL database, you can follow the steps below to connect and run the sql command:

  1. Open your WebHelpDesk home directory.
    Apple® OS X®: /Library/WebHelpDesk    
    Microsoft Windows®: \Program Files\WebHelpDesk    
    Linux: /usr/local/webhelpdesk
  2. Navigate to pgsql9\bin.
  3. Double-click pgadmin3.
  4. Click File > Add Server.
  5. Complete the fields in the New Server Registration window, and then click OK. 
    • Name: whd
    • Host: localhost (or the IP Address)
    • Port: 20293
    • Maintenance DB: postgres
    • Username: whd
    • Password: whd
  6. Expand Databases and highlight the whd database.
  7. Click the SQL magnifying lens icon open the Query Tool or SQL Editor.
  8. Type the scripts or commands that you want to run.
  9. Click Play or Execute.
  10. To view all deleted Request Types, execute:
    SELECT problem_type_name, problem_type_id FROM problem_type WHERE Deleted='1' 
    To restore the deleted Request Type, execute: 
    UPDATE problem_type SET Deleted='0' WHERE problem_type_id='<problem type id>' 
    For example, The Request Type (Problem Type) ID that you want to restore is 12. 
    UPDATE problem_type SET Deleted='0' WHERE problem_type_id='12' 

 

Last modified

Tags

Classifications

Public