How to change the ticket creator in spiceworks

Here, type in 2 (since we are going to be removing a range of tickets). After some possible errors (see below in the Gotchas), you should view something like this: Spiceworks Ticket Loop Tool Notice that there are no command line options (which is a shame) so you will now be using this tool interactively. You might have seen that in the main folder there is a file named ticket_delete.exe thatвЂ™s the command which is going to do all the work for us so letвЂ™s move onto that. Take a copy of that and store it somewhere safe - it contains the SQLite database file, backups and other files which you may need if things turn sour. LetвЂ™s now go to the directory Spiceworks is installed in, and there, you should see a folder named db. OK, the server has been removed from the running processes. By the way, there are methods you can use which use the GUI, but ultimately, the command line is best in my opinion because you are closer to the core commands that are often really run, anyway, and donвЂ™t have to contend with any HTTP timeouts etc. This should fairly quickly stop the server. Start this and then type the following command: > net stop spiceworks WeвЂ™re going to shut down Spiceworks next and to do that you will need an administrator shell on the server that your installation resides. You should now either have a start an end number for the tickets, or a whole set of of them, if there were any gaps in the sequences. IвЂ™m sure there are many other ways, but hopefully one of these will suffice. Lastly, you could see which was the latest ticket ID (that would be your max) and then use the range: 1 to that max number.Go directly to the database backend (see DB Browser below).Then, take the smallest and greatest for your range. Create/use a report in the GUI to show a list of closed tickets, ordered by ID.YouвЂ™ve got many options here but you could either: To start, letвЂ™s find out what range(s) of ticket numbers you have. Getting Candidate Tickets to DeleteДЇirstly, letвЂ™s remove the unwanted (old, closed) tickets from the database (if you want to keep them, you can use the backup database in a second instance). Spiceworks has an SQLite database to store all the information about tickets, but use it for a while, and soon you will end up with a huge file which causes Spiceworks to slow down or even crash.

How to change the ticket creator in spiceworks