Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Loyal Listener
Posts: 13
Registered: ‎03-31-2009

Deleting Groups from Architect, Plug in

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?   

Sheryl Jackson
Director of Information Services
Washington Restaurant Associaton
Sage Saleslogix Lan Client/ MAS 90
Highlighted
Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: Deleting Groups from Architect, Plug in

None, so long as you dont delete the system groups (Latest Accounts, Latest Contacts etc)

 

 

Regards, Adam Travers
empath-e Services Limited
Highlighted
Loyal Listener
Posts: 13
Registered: ‎03-31-2009

Re: Deleting Groups from Architect, Plug in

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.

Sheryl Jackson
Director of Information Services
Washington Restaurant Associaton
Sage Saleslogix Lan Client/ MAS 90
Highlighted
Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: Deleting Groups from Architect, Plug in

Good luck with that! It sounds painful.. Smiley Wink

Regards, Adam Travers
empath-e Services Limited
Highlighted
Bronze Super Contributor
Posts: 349
Registered: ‎03-24-2009

Re: Deleting Groups from Architect, Plug in

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)

Timmus Agersea
Black Moth CRM
Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Deleting Groups from Architect, Plug in

[ Edited ]

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

to

AND P.TYPE IN (8,23)

 

and

SELECT BASEDON FROM PLUGIN WHERE TYPE =8

to

SELECT BASEDON FROM PLUGIN WHERE TYPE IN (8,23)

 

to pick up the "other" groups ;-)

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html