cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AEMIT
Engaged Sweeper II
Howdy,

To save us some reporting headaches/overlap/confusion etc... we'd like to start the ticket # at say 9000

I found the article on how to reset it, but was not able to figure out how to go the opposite direction.

Any ideas?

Thanks!
1 ACCEPTED SOLUTION
AEMIT
Engaged Sweeper II
Esben.D wrote:
I honestly would not know other than to create 9000 fake tickets with a script, delete them and then continue.


Thanks! While searching this I stumbled upon this result which I was able to use:
https://www.lansweeper.com/forum/yaf_postsm47398findlastpost_deleting-all-imported-tickets.aspx#post47398

If the link goes away

[This easily clears out the existing tickets]
delete from htblticket;

[I changed the value from 1000 to 9000 to start at the desired #]
DBCC CHECKINDENT (htblticket, RESEED, 9000)

View solution in original post

2 REPLIES 2
Esben_D
Lansweeper Employee
Lansweeper Employee
I honestly would not know other than to create 9000 fake tickets with a script, delete them and then continue.
AEMIT
Engaged Sweeper II
Esben.D wrote:
I honestly would not know other than to create 9000 fake tickets with a script, delete them and then continue.


Thanks! While searching this I stumbled upon this result which I was able to use:
https://www.lansweeper.com/forum/yaf_postsm47398findlastpost_deleting-all-imported-tickets.aspx#post47398

If the link goes away

[This easily clears out the existing tickets]
delete from htblticket;

[I changed the value from 1000 to 9000 to start at the desired #]
DBCC CHECKINDENT (htblticket, RESEED, 9000)