Запрос для получения списка пользователей/групп в Cognos Analytics

SELECT 
	v_user.ldap_id as USERNAME, 
	v_group.name as GROUPNAME
--  v_group_user.cmid as GROUP_ID,
--	v_group_user.refcmid user_id 	
FROM [ca11_cm]..cmreford1 as v_group_user
LEFT OUTER JOIN (
	SELECT 
		c33.cmid user_id, 
		UPPER (c33.NAME) ldap_id,
		c1.surname last_name, 
		c1.givenname first_name,
		c1.email email
	FROM [ca11_cm]..cmobjprops1 c1 
	left outer join [ca11_cm]..cmobjprops33 c33 on c33.cmid = c1.cmid
	UNION
	SELECT 
		cmobjprops1.cmid user_id, 
		UPPER (cmobjprops33.NAME) ldap_id, 
		cmobjprops1.surname last_name, 
		cmobjprops1.givenname first_name, 
		cmobjprops1.email
		FROM [ca11_cm]..cmobjprops1, [ca11_cm]..cmobjprops33
		WHERE cmobjprops1.cmid = cmobjprops33.cmid
	) v_user
	ON v_group_user.refcmid = v_user.user_id
LEFT OUTER JOIN (
	SELECT 
		cmobjnames.cmid cmid, 
		UPPER (cmobjnames.NAME) name,
		cmobjects.created created, 
		cmobjects.modified modified, 
		cmobjects.disabled disabled
	FROM [ca11_cm]..cmobjects, [ca11_cm]..cmobjnames
	WHERE cmobjects.classid IN (26, 54)
			AND cmobjnames.mapdlocaleid = 352
			AND cmobjects.cmid = cmobjnames.cmid
	) v_group
	ON v_group.cmid = v_group_user.cmid