How to delete "a lot" of tickets on DB-side?
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
Hi,
Try to use
Admin >> Generic Agent
You can select the tickets of a specific condition, on this case are a
queue, and the end of the page is the option to delete the tickets.
Regards.
2011/8/1 Alexander Rothenberg
**
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
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
On Monday 01 August 2011 18:25:46 Carlos Andrés Gallego Arboleda wrote:
Hi, Try to use Admin >> Generic Agent
You can select the tickets of a specific condition, on this case are a queue, and the end of the page is the option to delete the tickets.
That did it, thx a lot. 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
Le 2011-08-01 11:46, Alexander Rothenberg a écrit :
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...
participants (3)
-
Alexander Rothenberg -
Carlos Andrés Gallego Arboleda -
Ugo Bellavance