Notification

Icon
Error

Starting ticket # for helpdesk - Looking to change the starting number for helpdesk tickets

Posted: Monday, October 7, 2019 4:16:37 PM(UTC)
AEM IT

AEM IT

Member Original PosterPosts: 4
0
Like
This issue has been solved! Click here to view the solution
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!
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 10/18/2019 10:13:21 AM(UTC)
I honestly would not know other than to create 9000 fake tickets with a script, delete them and then continue.
AEM IT
#2AEM IT Member Original PosterPosts: 4  
posted: 10/21/2019 5:17:22 PM(UTC)
Originally Posted by: Esben.D Go to Quoted Post
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.c...d-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)

Active Discussions

Lansweeper Unable to send to External Email
by  pryan67   Go to last post Go to first unread
Last post: Yesterday at 8:21:01 PM(UTC)
Lansweeper Lansweeper assets not being Scanned
by  Jordan  
Go to last post Go to first unread
Last post: Yesterday at 6:42:22 PM(UTC)
Lansweeper Database size growing too large
by  bladd   Go to last post Go to first unread
Last post: Yesterday at 4:26:44 PM(UTC)
Lansweeper Searching Specific File
by  mzipperer  
Go to last post Go to first unread
Last post: Yesterday at 4:23:29 PM(UTC)
Lansweeper Exchange 2010 information is not populating
by  Moe   Go to last post Go to first unread
Last post: Yesterday at 12:30:38 PM(UTC)
Lansweeper Routinely Exploited Vulnerabilities Query Report
by  pryan67  
Go to last post Go to first unread
Last post: Yesterday at 12:25:31 PM(UTC)
Lansweeper Creating a report for new devices every 2 hours to alert
by  Moe   Go to last post Go to first unread
Last post: 6/4/2020 7:26:11 PM(UTC)
Lansweeper Changes in the licensing model
by  BullGates  
Go to last post Go to first unread
Last post: 6/4/2020 6:27:23 PM(UTC)