Reset LabTech Ticket count to #1

Hey,

So…you wanna start from scratch do ya? You finally figured what Template, Service Plan or Monitor, etc… was creating all that noise and finally you have it under control and now you just want to start from Ticket # 1 again, instead of carrying on from where all that noise left you…at Ticket #152,487 ;)

First thing we need to do is get into your LabTech MySQL database and we can do that easily with SQLyog! If you don’t have it already, you can download the latest version from this page…

Tip: Stay away from BETA versions of SQLyog when modifying your live LT database! ;)

Once you’re in the database, double check that your LabTech database (most commonly named labtech) is set as your default schema & be sure that the LabTech Control Center is not running on the server

Please note: If you have ticket integration with ConnectWise setup, the following procedure will NOT modify any tickets that are in ConnectWise system.

Run the following SQL Query:

1
DELETE FROM tickets;

Next, we have to ‘reset’ the Auto-increment to value 1. To do this, do the following:

  • Right click on the table: tickets
  • Select Alter Table
  • Select tab (4) Advanced
  • Change the Auto-Increment value to 1
  • Click Save

That takes care of the tickets, but the database is still full of ticket ‘data’, so… here is the second SQL query:

2
DELETE FROM ticketdata;

Again, we have to reset the Auto-increment value to 1. To do this, do the following:

  • Right click on the table: ticketdata
  • Select Alter Table
  • Select tab (4) Advanced
  • Change the Auto-Increment value to 1
  • Click Save

You can now close out of SQLyog and re-open your LabTech Control Center on your server and /or workstations.

When you go back into the LT CC and go to the Tickets tab, you should see NO tickets, and the next one that does come in…will be Ticket #1.

If things don’t look as expected on some workstations, go to Tools > Reload System Cache.

Tags: , , , ,

No comments yet.

Leave a Reply