Reset ticket starting number

Creation date: 5/17/2017 2:46 PM    Updated: 1/15/2023 4:11 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 on-premises version of Jitbit Helpdesk ticketing system