Reset ticket starting number

Creation date: 5/17/2017 2:46 PM    Updated: 9/16/2025 7:58 PM

Question

How can you change the ticket starting number on the self-hosted version? E.g., rather than 6,7,8,9,10…. For the next few tickets I would prefer 15106, 15107, 15108, 15109, 15110.

Answer

You can achieve that by running this command

DBCC checkident ('hdIssues', reseed, 1000)

at your SQL server, against the helpdesk database

Solving problems with the on-prem, self-hosted version of Jitbit Helpdesk ticketing system