cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
drtag8
Engaged Sweeper
working on an import from spiceworks. I imported 8000 tickets without notes and now need to delete them.

any ideas where to start?
1 REPLY 1
drtag8
Engaged Sweeper
ok here's what I did to delete tickets.

from database scripts:


//delete tickets
delete from htblticket;

//then reset ticket # to begin at 1000
DBCC CHECKIDENT (htblticket, RESEED, 1000)


so far so working, going to re-import and attempt all ticket notes / comments

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now