What is the best way to delete unused Groups in SalesLogix?

 Question:

After several years of using SalesLogix – we have hundreds of groups, most of which are no longer used as they were created on the fly.

It
looks like the best way to tackle them in mass is thru the Architect,
PlugIn.  Is there any known harm in deleting groups from the Plug In
feature of Architect?  

Answer:

You can certainly delete them from the Architect Group manager, but could be a lengthy process.

The following SQL returns a list of unshared groups created by a
retired user.  You could use this to write a delete statement so you
don’t have to manually delete the records.

SELECT

  p.*

FROM

  USERINFO U

  INNER JOIN USERSECURITY US ON US.USERID = U.USERID

  INNER JOIN PLUGIN P ON P.USERID = U.USERID

WHERE

  P.BASEDON IS NULL AND US.TYPE = ‘R’ AND P.TYPE = 8

  AND P.PLUGINID NOT IN (SELECT BASEDON FROM PLUGIN WHERE TYPE = 8 AND BASEDON IS NOT NULL)

This statement does not include the other groups. To include those you would have to include Type-23