RE: Deleting huge list of inactive users

[M IN BLR SISL Srivathsan]

Hi Sanjay,

To answer your question partially, you could probably fire an SQL
Query(s) to delete records pertaining to the inactive users from the
MySQL Query Browser on the following tables:

	eventum_user - Main User Table

	eventum_project_user - User <-> Project Association Table
	eventum_issue_user - User <-> Issue Association Table

	{--- Not sure about these Tables ---}
	eventum_issue_user_replier
	eventum_round_robin_user
	eventum_search_profile

Please note that there could be other Tables which could be cleaned up.
But I could only find these and let somebody else in the group to
validate the above (partial) solution and accordingly inform us.

Also, the "eventum_" prefix could be different in your setup.

Thanks and rgds,
Watson

-----Original Message-----
From: Sanjay Madan [mailto:mediatwentyone@stripped] 
Sent: Fri, 04-Aug-2006 23:55
To: eventum-users@stripped
Subject: Deleting huge list of inactive users

Hi there

Hopefully someone can help me out.

We have a huge list of inactive users over various projects and its
becoming difficult to administer Eventum. Has anyone got a script that
we can run to remove the inactive users or all users except the
adminstrator? Or which tables do we need to clean out directly in the
database?

Many thanks

James