I, thanks a lot for your help....
The util "rt-delete-tickets-mysql" seems to be perfect for what I want.... I just have to change the initial query from: "DELETE FROM Tickets WHERE Status = deleted" to "DELETE FROM Tickets WHERE LastUpdate = '2 year ago'" Now I just have to find the right query... Again thanks a lot for your help... I didn't know about that utils package... Cheers *Flávio Moringa* Project Leader Caixa Mágica Software Energia Open Source Rua Soeiro Pereira Gomes, Lote 1 - 4.º B, Edifício Espanha, 1600-196 Lisboa - Portugal Tel.: +351 217 921 260 Fax: +351 217 921 261 http://www.caixamagica.pt https://twitter.com/flaviomoringa https://www.facebook.com/flaviomoringa<https://www.facebook.com/flavio.moringa> http://pt.linkedin.com/in/flaviomoringa http://people.caixamagica.pt/flaviomoringa 2013/4/9 Bart <[email protected]> > This page contains the info on the command: > > > - http://bestpractical.com/rt/docs/3.8/rt-shredder.html > > > And some info if you want to use the API: > > > - http://bestpractical.com/rt/docs/3.8/RT/Shredder.html > > > Another thing you might want to look at are the extension Utils: > > > - > http://search.cpan.org/~ruz/RT-Extension-Utils/lib/RT/Extension/Utils.pm > - http://search.cpan.org/~ruz/RT-Extension-Utils/MANIFEST > > > As Kevin puts it, Utils are Ruslans bag of tricks. It also contains a > commando for extracting attachments/deleting tickets, so maybe that's what > you can use to make things a bit more easy. (the manifest page shows the > included commands) > > > Hope this helps a little. > > > > 2013/4/8 Flavio Moringa <[email protected]> > >> I guys, >> >> I haven't come across a straight answer to this, so my apologies if this >> has been answered before. >> >> I have a 3.6 Request Tracker instance running.... (and no.. updating >> right now is not possible).... >> >> I want to delete all tickets (and respective attachments, etc) that are >> older than 2 years... >> >> My approach is using rt-shredder... by installing the cpan module ( >> http://search.cpan.org/dist/RTx-Shredder/lib/RTx/Shredder.pm) >> >> So what is the cli command to do this? I don't need backups.. so no dump >> is required.... >> >> I have about 600 Gb worth of data.... 99% on the attachments table.... >> And want to clean all this up... >> >> There is an answer on the mailling list about this on Jul 13, 2004... >> that simply says that to delete for a giving year do: >> >> rtx-shredder YYYY-MM-DD >> >> But seems to old... >> >> Can you help me? seems like a basic think to do... >> >> Thanks in advance. >> >> Yours trully >> >> *Flávio Moringa* >> Project Leader >> >> >> >> Caixa Mágica Software >> Energia Open Source >> Rua Soeiro Pereira Gomes, Lote 1 - 4.º B, >> Edifício Espanha, 1600-196 Lisboa - Portugal >> Tel.: +351 217 921 260 Fax: +351 217 921 261 >> http://www.caixamagica.pt >> https://twitter.com/flaviomoringa >> https://www.facebook.com/flaviomoringa<https://www.facebook.com/flavio.moringa> >> http://pt.linkedin.com/in/flaviomoringa >> http://people.caixamagica.pt/flaviomoringa >> >> > > > -- > Bart G. >
