[rt-users] cli command to delete old tickets with shredder

[Flavio Moringa]

Huumm... still didn't  try it but this query should do the trick:

DELETE FROM Tickets WHERE Created <= date_sub(NOW(), interval 2 year);

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 Flavio Moringa <flavio.moringa at caixamagica.pt>

> 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 <bart at pleh.info>
>
>> 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 <flavio.moringa at caixamagica.pt>
>>
>>> 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.
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130409/0ff71b7f/attachment.htm>