Submit a ticketCall us

WebinarFREE IT Monitoring Webcast

Don’t miss out on our webcast, Essential IT Monitoring with SolarWinds ipMonitor, where we will show you how to keep an eye on your IT environment from one centralized, affordable, and lightweight monitoring tool: SolarWinds® ipMonitor®.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Change the Web Help Desk ticket numbering

Change the Web Help Desk ticket numbering

Table of contents
Created by Renato Quejas, last modified by Caroline Musindi on Jul 14, 2017

Views: 804 Votes: 0 Revisions: 5

 

Overview

This article will show you on how to change the ticket numbering or ticket starting number.

Environment

All WHD versions

Steps

For Embedded PostgreSQL:

  1. Run the pgAdmin3.exe (as admin) under ..\Program Files\WebHelpDesk\pgsql9\bin.
  2. Go to File > Open pg_hba.conf under ..\Program Files\WebHelpDesk\pgsql9\data.
  3. Double click the line host all all 127.0.0.1/32 password.
  4. Change the method from 'password' to 'trust' then save (do not close the pgAdmin3.exe). 
  5. Restart the Web Help Desk PostgreSQL Embedded Database service (start > run > services.msc).
  6. From pgAdmin3.exe, go to File > Add Server > add the following then click OK.
    • Name: whd
    • Host: 127.0.0.1
    • Port: 20293
    • Maintenance DB: choose 'template1'
    • Username: whd
    • Password: <leave as blank>
  7. Expand Databases and you should see the 'whd'.
  8. Expand the Schemas > Sequences > and look for job_ticket_seq.
  9. Right click job_ticket_seq > Properties.
  10. Under Definition tab, you will see the current value or last number of the ticket. 
    Change the current value or ticket number and this will be the starting ticket number. 
  11. Click OK.

 

MySQL/MSSQL

Select the [EO_PK_TABLE] table then run the SQL query below: 

UPDATE [dbo].[EO_PK_TABLE] SET PK='<ticket number>' where NAME='JOB_TICKET'

 

Last modified

Tags

Classifications

Public