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 Change the Callto: link to Tel:
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 2:05:38 AM(UTC)
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)