Delete all tickets

RT Users
1

Hi,

I’d like to know if it’s possible to get all the ticket generated erased
without usings SQL command on the database,
so to get for the next ticket creation the number #1.

Thanks

2

MessageIve been trying to get an answear to this, but realised that the most simple thing is to drop the DB, and
then copy the userdatabase…to the new one and recrate the queues.

They told me that there is scripts to do this to but then you can take 1 ticket at each time.
Also there is something that is called RTx:Shredder that you can build your own script around.

//Jonas----- Original Message -----
From: Sivan DERAY
To: rt-users@lists.bestpractical.com
Sent: Wednesday, July 28, 2004 11:18 AM
Subject: [rt-users] Delete all tickets

Hi,

I’d like to know if it’s possible to get all the ticket generated erased without usings SQL command on the database,
so to get for the next ticket creation the number #1.

Thanks

The rt-users Archives

Be sure to check out the RT wiki at http://wiki.bestpractical.com

3

Jonas Lindvall (AllTele) wrote:

Ive been trying to get an answear to this, but realised that the most
simple thing is to drop the DB, and
then copy the userdatabase…to the new one and recrate the queues.

They told me that there is scripts to do this to but then you can take 1
ticket at each time.
Also there is something that is called RTx:Shredder that you can build
your own script around.

If you want wipeout deleted tickets then you shouldn’t write anything
for RTx::Shredder.

			Best regards. Ruslan.
4

Hi,

I run into some strange problems when calling LoadQueueTemplate.
What I’m trying to do is to load a local template based on its name and the
queue name. It is working properly only when there’s a global template with
the same name. However, when I delete the global template (since all the
queues have their own local template, so I don’t need the global one), local
templates are not being loaded.

Is it how it was intended to work or it’s a bug?

Dimitry Faynerman