Good day,
I need to clear out all old data from our RT instance. We’re currently running 4.4.1. I’ve got a script setup to use RT_Shredder to clear out tickets with a type of ‘ticket’, but am unable to shred those with a type ‘reminder’. The reminders are viewable in RT, and I don’t see any linked ticket info there. I can only assume the original ticket has already been deleted. I can even run RT_Shredder pointing directly at the ticket and I receive “Objects list is empty, try refine search options”.
How can I go about deleting these old reminders? I’ve got half a mind to update the type to ‘ticket’ directly in the database, but am unsure what that may break.
Thank you!
Sebastian
Well, reminders are just a type of the ticket as you write. What if you change the status to ‘deleted’ and then search for the status and shred it? It’s a hack but may work 
BTW I’ve tried it and it works as desired:
/opt/rt4/sbin/rt-shredder --plugin ‘Tickets=query,Queue=“support” AND Type = “reminder”’
SQL dump file is ‘/root/20190208T111909-0001.sql’
Next 10 objects would be deleted:
RT::Ticket-example.org-156283 object
RT::Ticket-example.org-156303 object
RT::Ticket-example.org-160596 object
RT::Ticket-example.org-160611 object
RT::Ticket-example.org-160996 object
RT::Ticket-example.org-161002 object
RT::Ticket-example.org-161006 object
RT::Ticket-example.org-161664 object
RT::Ticket-example.org-179434 object
RT::Ticket-example.org-257578 object
The last reminder (ticket #257578) I’ve created just few minutes ago. Using RT 4.2.15 and it’s shredder now.
Petr
Hey Petr,
Thanks for your reply, you’ve proven some interesting results! It seems that the query string requires you to set the type as a reminder, otherwise it doesn’t check for them.
This does NOT work
"Tickets=query,ID = idnum"
This does work
"Tickets=query,ID = idnum AND Type = 'reminder'"
At this point, I’m just gonna delete all existing reminders using the shredder and then disable them.
Thanks again!
Sebastian