CA SDM::. Query to Retrieve analysts that are not members of any groups

Document created by TMACUL Champion on Feb 16, 2017
Version 1Show Document
  • View in full screen mode

How to Retrieve analysts that are not members of any groups


SELECT        ca_contact.userid, ca_contact.first_name, ca_contact.last_name, acctyp_v2.licensed, acctyp_v2.access_level, acctyp_v2.sym AS access_type
FROM            usp_contact INNER JOIN
                         ca_contact ON usp_contact.contact_uuid = ca_contact.contact_uuid LEFT OUTER JOIN
                         acctyp_v2 ON usp_contact.c_acctyp_id =
WHERE        (acctyp_v2.access_level >= 20) AND (acctyp_v2.licensed = 1) AND (ca_contact.inactive <> 1) AND
                             ((SELECT        COUNT(*) AS Expr1
                                 FROM            grpmem
                                 WHERE        (member = usp_contact.contact_uuid)) = 0)


By Jerome Mayer 




Summary CA SDM  MS SQL Querys - TSQL 

1 person found this helpful