Submit a ticketCall us
Home > Success Center > Web Help Desk (WHD) > Ticket types in the database

Ticket types in the database

Table of contents

Updated March 6, 2018

Overview

This article describes how to produce an external report of the SolarWinds Web Help Desk (WHD) platform to identify which tickets are Service Requests, Problems or Incidents based on data in the PostgreSQL database. This data does not seem to be included in the primary Job_Ticket table.

Environment

WHD 12.x

Detail

To determine if the ticket is a Service Request, Problem or Incident, use column "isHot" in table job_ticket:

Values:
NULL or blank = Service Request
1 = Problem
2 = Incident

See the Web Help Desk REST API Guide for details.

 

 

Last modified

Tags

Classifications

Public