Cognos users and group list using Content manager


I used below query to get cognos user list and associated groups.  I got this query for cognos version 10.2.2

If query doesn’t provide any data, change classid and  mapdlocaleid  values and try.

SELECT AS group_name,
v_user.ldap_id AS user_name
FROM dbo.cmreford1 AS v_group_user
JOIN (SELECT cmid user_id,
UPPER (NAME) ldap_id
FROM dbo.cmobjprops33) v_user
ON v_group_user.refcmid = v_user.user_id
JOIN (SELECT cmobjnames.cmid cmid,
UPPER(cmobjnames.NAME) name

FROM dbo.cmobjects, dbo.cmobjnames
WHERE cmobjects.classid IN (26, 54)
AND cmobjnames.mapdlocaleid = 96
AND cmobjects.cmid = cmobjnames.cmid) v_group
ON v_group.cmid = v_group_user.cmid
order by 1,2

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s