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 > 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 "is_hot" 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