Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > 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