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

 

Submit a Comment

Your email address will not be published.

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!