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