10-04-2010 08:11 AM
After several years of using SLX – 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?
10-04-2010 08:27 AM
Nothing crazy like that.... I was planning on tackling them by pulling Non-released groups created by former employees. Then reviewing released groups by former employees to see if they are still valid groups - if so, change the "developer" to a current employee. delete those no longer needed. Then review 'unreleased" groups by current team members... right there should clean up over 50% of our groups.
10-05-2010 12:58 PM
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.
INNER JOIN USERSECURITY US ON US.USERID = U.USERID
INNER JOIN PLUGIN P ON P.USERID = U.USERID
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)
10-05-2010 03:20 PM - edited 10-05-2010 03:26 PM
Great SQL Timmus!
I've used this before (remember the partner NG's.. it's still there!).
However, I've changed
AND P.TYPE = 8
AND P.TYPE IN (8,23)
SELECT BASEDON FROM PLUGIN WHERE TYPE =8
SELECT BASEDON FROM PLUGIN WHERE TYPE IN (8,23)
to pick up the "other" groups ;-)