oops! On Di, 2007-11-27 at 10:07 +0100, Sven Sternberger wrote: > But rtx-shredder don't give you a simple way to delete all > users without a ticket, so you have to combine the select > statement from Gordon, and then call rtx-shredder
so Geordons sql statemaent is of course not correct (for most of us) we have a lot of valid users who never owned a ticket. So replace Ticket.owner with Transaction.creator, which gives us all users where we deleted their tickets via rtx-shredder. regards! sven _______________________________________________ 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
