[rt-users] BULK shredding?

[Ruslan Zakirov]

On 12/22/05, Howard Jones <howard.jones at network-i.net> wrote:
> I've just been looking into using RTx-Shredder to kill off our deleted
> tickets (55000 tickets now, and probably 80% deleted).
> However using the obvious incantation from the documentation:
>
>     ./rtx-shredder --sqldump unshred.2005-12-21.B.sql --plugin
> 'Tickets=status,deleted'
>
> it offers to delete 10 tickets. Running it again deletes another 10. Is
> there an option to shred ALL the matching tickets? I couldn't see one in
> the docs... From the web interface, there's a limit you can set, but if
> you set it high then the URI is too long for the RT web dispatcher
> ('high' seems to be <500).
>
> Can I specify a limit on the CLI version (bypassing any URI problems)?
Yes, you can. CLI has the same set of options for plugins.
./rtx-shredder --sqldump unshred.2005-12-21.B.sql --plugin
'Tickets=status,deleted;limit,500'

I wouldn't suggest you to delete more then 1000 tickets at once.

>
> I don't mind if it takes a while, just so long as it doesn't require
> poking every 10 minutes :-)
>
> Best Regards,
>
> Howard Jones
>
> (Incidentally, the Shredder Web UI didn't work in IE6 at all - the
> show/hide for the plugin options didn't trigger. I used Firefox and it
> worked fine).
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
>
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
>


--
Best regards, Ruslan.