Ticket Pruning

tlombardi · Post by **tlombardi** » 26 Jan 2009, 15:55

Hi Guys,

is there a way to prune tickets in OTRS? I don't want my database to grow extremely large and I want to delete tickets older than for example a year. Is there a way to do this from within OTRS? If not, which tables should I touch to delete the tickets?

Regards,

Tonio

King_Darki · Post by **King_Darki** » 26 Jan 2009, 16:11

if you want to delete tickets from your DB then:
open your SQL-database, search for table 'ticket' and delete the tickets you want...

but you will have troubles with inconsistency if you delete the tickets... you should better set them to 'invalid'!

Player1975 · Post by **Player1975** » 26 Jan 2009, 17:09

...the easiest and best way to delete tickets is to use the GenericAgent.

Best regards,

Dirk

King_Darki · Post by **King_Darki** » 26 Jan 2009, 17:39

Player1975 wrote:...the easiest and best way to delete tickets is to use the GenericAgent.

Best regards,

Dirk

oder so... dass ich an das nicht gedacht hab... *schäääm*