COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Ravisha on 26 Jul 2016 05:22:14 PM

Title: Users List and their Capabilities
Post by: Ravisha on 26 Jul 2016 05:22:14 PM
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
Title: Re: Users List and their Capabilities
Post by: Kiran P on 27 Jul 2016 02:03:39 AM
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
Title: Re: Users List and their Capabilities
Post by: Ravisha on 29 Jul 2016 08:33:49 AM
Hi

Thanks a ton.

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

I really appreciate your help.  ;D