Users List and their Capabilities

[Ravisha]

Hi All,

We are using Cognos 10.1.1 on a windows platform.

I'd like to know if there is any way to retrieve the list of users and their capabilities. I've been asked by the Auditors to create such report. I know that the MotioPI and the other third party tools are capable of it. But, I'm looking for a T-SQL Query which I can run against the content store to retrieve the information and plug it in the report.

Any help would be greatly appreciated.

Thanks

[Kiran P]

Hi Ravisha,

Look at the link below.

http://www-01.ibm.com/support/docview.wss?uid=swg24034217

IBM provides a tool to retrieve all users with their capabilities, groups and roles they belong to etc.

Hope this helps.

Kiran

[Ravisha]

Hi

Thanks a ton.

Although the app is very slow; it gave  me what I was looking for.

I really appreciate your help.  ;D