Cognos Analytics

Hi,

We are using Cognos 11.2.4 on Cloud.

I am looking for a way to get the list of all users in Cognos with their Roles and Privileges. Motio PI is the answer but it is currently not working for us due to some security issues. Is there any other way like directly accessing the Content database or Audit tables or some kind of SDK. I found something called IBM Cognos BI Users and Capabilities Tool but the tool is not available now.

Please help

Sachin

Hi Sachin,

You can probably obtain this by using the Cognos Analytics API interface ; there are functions available to list roles & capabilities and retrieve members accordingly. for more info see "https://<your ca install localhost:9300>/api/api-docs" and corresponding documentation

Hi @Sachin Kandalgaonkar - cocoma can do that.

There is an option which is not in the documentation "--dumpaccounts" and "--dumpSecurityAndAccounts".

You need java knowledge to compile and Cognos libraries, which are inside your Cognos installation.

Greetings,

Ralf

In SQL Server this shows Roles and Groups

SELECT v_group.name AS group_name,
v_user.ldap_id AS user_name
, CLASSID
, MAPDLOCALEID

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
, cmobjects.classid
, cmobjnames.mapdlocaleid

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

------------------------------
brenda grossnickle
BI Programmer Analyst
FIS
------------------------------