Hi List, I'm cleaning out RT with rtx-shredder and have vast amounts of old spam to remove.
I'm looking for a solution/query to list all users with no tickets this I believe will considerably cut down the huge list of spam emails to remove. I have tried the no_tickets Boolean option in rtx-shredder but returns no results, I'm not sure what arguments the Boolean accepts, tried true? I'm wondering if this could be done from the rt command line or with an SQL query, just looking for a point in the right direction. Also any comment on cleaning out RT greatly accepted. I'm using the latest version of RT with Pg backend. Thanks, Kevin _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If you sign up for a new RT support contract before December 31, we'll take up to 20 percent off the price. This sale won't last long, so get in touch today. Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745. Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
