Hi Paul,
About group is it providing the report ?I need access type, group and role for user . Access type and group field is there .Please suggest about group field.
Query:
SELECT ca_contact.first_name,
ca_contact.last_name ,
ca_contact.userid,
ca_contact.middle_name,
ca_contact.inactive as Active,
ca_contact.email_address,
ca_contact_type.name as ContactType,
usp_contact.c_acctyp_id,
acctyp_v2.sym as AccessType,
usp_role.name as rolename
FROM ca_contact INNER JOIN ca_contact_type ON ca_contact_type.id = ca_contact.contact_type INNER JOIN usp_contact ON ca_contact.contact_uuid = usp_contact.contact_uuid
INNER JOIN acctyp_v2 ON usp_contact.c_acctyp_id = acctyp_v2.id INNER JOIN usp_cnt_role ON usp_contact.contact_uuid= usp_cnt_role.contact
INNER JOIN usp_role ON usp_cnt_role.role_obj = usp_role.id
where first_name!='' and ca_contact.inactive = '0'
Regards,
Jagatjyoti Dash