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: 3
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,930  
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: 3  
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 Check if Netbios is disabled over TCP/IP
by  Wesker305  
Go to last post Go to first unread
Last post: Yesterday at 5:43:02 PM(UTC)
Lansweeper Ticket Info Meter incorrect
by  pfalls   Go to last post Go to first unread
Last post: Yesterday at 4:32:21 PM(UTC)
Lansweeper OS: Not latest Build of Windows 10 report
by  RKCar  
Go to last post Go to first unread
Last post: Yesterday at 3:08:52 PM(UTC)
Lansweeper Windows Defender AV
by  Mikey!   Go to last post Go to first unread
Last post: Yesterday at 2:48:54 PM(UTC)
Lansweeper Allow Users and cc Users to edit ticket form field
by  eoinpryan  
Go to last post Go to first unread
Last post: Yesterday at 12:41:05 PM(UTC)
Lansweeper Mobile App
by  jdvuyk   Go to last post Go to first unread
Last post: Yesterday at 2:28:56 AM(UTC)
Lansweeper Duplicate Asset 1 Mac address, 1 domain\computer\1
by  jstrong71  
Go to last post Go to first unread
Last post: 11/12/2019 9:16:58 PM(UTC)