AW: Re: [rt-users] clean up user table

Sven Sternberger sven.sternberger at desy.de
Tue Nov 27 04:42:46 EST 2007


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 





More information about the rt-users mailing list