Using SQL to Identify Users Associated With Particular Teams in SalesLogix v7.2.1

Question: I’m running SalesLogix v7.2.1 and am having trouble trying to figure out
how to use SQL to determine who belongs to what teams.  How can I do
this?

Answer: This should work for you:

SELECT info.UserName, code.Seccodedesc

FROM SLXFixed_Prod.sysdba.userinfo info
inner join SLXFixed_Prod.sysdba.Secrights rights
on info.userid = rights.accessid
inner join SLXFixed_Prod.sysdba.Seccode code
on code.seccodeid=rights.seccodeid
where code.seccodetype=’G’
and Seccodedesc=’Insert Group Name’

 

 

 

Submit a Comment

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

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!