[rt-users] Pruning Users

Vivek Khera khera at kcilink.com
Mon Sep 15 14:06:21 EDT 2003


>>>>> "RW" == Robert Westendorp <rjwsys at uniserve.com> writes:

RW> Does anyone have a script that will go through and remove users that don't
RW> have any affiliation with any tickets (ie removed dead tickets)? We
RW> currently have about 50000 users (Mostly non-priviledged users) and was
RW> wondering if anyone had a quick way of cleaning those up.

Sounds like a job for a LEFT JOIN in sql.  Are there any tables that
reference user IDs other than the tickets table?  If so, then you'll
have to chase after those tables and delete as well.  Otherwise you
can just delete based on the join.




More information about the rt-users mailing list