Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Web Help Desk (WHD) > 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: 103 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
14:42, 14 Jul 2017

Tags

Classifications

Public