Hi,

we use OTRS 2.3.4 and mysql 5 as its database.

Due to an issue on our side, a few thousand useless tickets have been created :(

I have adminrights on that OTRS-system but i cannot find any option to delete all tickets of a specific queue.

I would like to delete them in a "clean" way from the database but therefore i have to know the complete list of which tables?

I can identify all tickets by the queue_id of the tickets-table. They are all unanswered and have no edits...

Thx and regards

--

Alexander Rothenberg

Fotofinder GmbH USt-IdNr. DE812854514

Software Entwicklung Web: http://www.fotofinder.net/

Potsdamer Str. 96 Tel: +49 30 25792890

10785 Berlin Fax: +49 30 257928999

Geschäftsführer: Ali Paczensky

Amtsgericht: Berlin Charlottenburg (HRB 73099)

Sitz: Berlin