How can I query the SalesLogix database to find all groups and the persons/teams that the group have been released?

 Question:

I want to create a report from the database that shows each group and
each person the group has been released to.  I would like to write an
SQL statement that extracts that information directly from the database
so that we can see all of the groups with all of the people they have
been released to all at once. 

Answer:

You will need to query the Plugin table Where Type = 8

 

Here is an example to get you started:

 

SELECT
sysdba.PLUGIN.NAME AS GroupName,sysdba.USERINFO.USERNAME AS GroupOwner,
sysdba.SECCODE.SECCODEDESC AS ReleasedTOUser, sysdba.PLUGIN.FAMILY,
sysdba.PLUGIN.TYPE

FROM sysdba.PLUGIN LEFT OUTER
JOIN sysdba.SECCODE ON sysdba.PLUGIN.USERID = sysdba.SECCODE.SECCODEID
LEFT OUTER JOIN sysdba.USERINFO ON sysdba.PLUGIN.USERID =
sysdba.USERINFO.USERID

WHERE (sysdba.PLUGIN.TYPE = 8)

ORDER BY sysdba.PLUGIN.NAME

 

Want content like this delivered to your inbox? Sign up for our newsletter!

Submit a Comment

Your email address will not be published. Required fields are marked *