Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Web Help Desk (WHD) > Unmerge tickets in WHD

Unmerge tickets in WHD

Table of contents
Created by Renato Quejas, last modified by MindTouch on Jun 23, 2016

Views: 139 Votes: 0 Revisions: 4

Overview

This article provides information on how to unmerge tickets in WHD. Unmerging the tickets can be done through the Web Help Desk database (i.e PosgreSQL, MS SQL, MySQL).

Environment

  • All versions of WHD
  • All versions of Windows
  • All versions of Linux 
  • All versions of OS X 

Steps

Here are the commands that you need to run to perform the following:

  • Find the merged tickets:

SELECT MERGED_PARENT_TICKET_ID FROM JOB_TICKET WHERE JOB_TICKET_ID = <TICKETID>

  • Unmerge tickets:

UPDATE JOB_TICKET SET MERGED_PARENT_TICKET_ID = NULL WHERE JOB_TICKET_ID = <parentID>

 

Last modified
05:01, 23 Jun 2016

Tags

Classifications

Public