Tools

Change the Web Help Desk ticket numbering

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

First published date

11/8/2018 12:09 PM

Last published date

7/16/2020 2:58 PM

Overview

There are times that the ticket starting numbers has to be modified. This article will show you on how to change the ticket numbering or ticket starting number.

Product section

Web Help Desk

Resolution

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 'postgres'
    • Username: whd
    • Password: whd
  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'

Disclaimer: Scripts are not supported under any SolarWinds support program or service. Scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.