and this two querys to obtain all the basic info about your problem:
XXXXXXX = userid
YYYYYYYYY = CI name
SELECT cnt.userid
,cnt.inactive
,CONCAT(cnt.first_name,' ',cnt.last_name)
,grp.contact_uuid
,grp.inactive
,grp.last_name AS "group"
,grp.alternate_identifier
FROM grpmem
LEFT JOIN ca_contact cnt ON (grpmem.member = cnt.contact_uuid)
LEFT JOIN ca_contact grp ON (grpmem.group_id = grp.contact_uuid)
WHERE cnt.userid = 'XXXXXXX'
ORDER BY cnt.userid
SELECT
UPPER([dbo].[hex](nr.own_resource_uuid)) AS "UUID"
,nr.inactive
,nr.resource_name AS "Nombre"
,nr.resource_owner_uuid
,grp.inactive
,grp.userid AS "resource_owner userid"
,grp.last_name AS "resource_owner lastname"
,member.inactive
,CONCAT(member.first_name,' ',member.last_name) as "member"
FROM ca_owned_resource nr
LEFT JOIN ca_contact grp ON (nr.resource_owner_uuid = grp.contact_uuid)
LEFT JOIN grpmem ON (grp.contact_uuid = grpmem.group_id)
LEFT JOIN ca_contact member ON (grpmem.member = member.contact_uuid)
WHERE nr.inactive = 0
AND nr.resource_owner_uuid is not null
AND nr.resource_name in ('YYYYYYYYY')
order by nr.resource_name