COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: Ravisha on 27 Oct 2021 03:51:58 PM

Title: Content Store query to fetch permissions of an object
Post by: Ravisha on 27 Oct 2021 03:51:58 PM
How to query the Cognos Analytics content store to retrieve the permissions associated with an object. For example, if a report view is only allowed to be run for groups 'ABC' and 'DEF' (properties -> permissions), I'd like to pull the info from CS as following

CMID       ReportView Name                groups/roles      members
123      Revenue by Product Type            ABC                  sam
123      Revenue by Product Type            ABC                  mark
123      Revenue by Product Type            DEF                  john
123      Revenue by Product Type            DEF                  steven
Title: Re: Content Store query to fetch permissions of an object
Post by: Eric.Pleiss on 28 Oct 2021 08:48:06 AM
Hi Ravisha,
BSP Software has an admin tool that can help you do this with just a couple of clicks.  MetaManager is our Cognos admin tool and we have a document and security auditing tool that can give you exactly this, in a format of your choice.  And if you find security settings that are incorrect, you can easily update them with our drag and drop interface.

I'd be happy to pass along a free fully-functional 15-day trial to get you through this documentation process.  You can download the software here: https://www.bspsoftware.com/products/metamanager/#mm-download (https://www.bspsoftware.com/products/metamanager/#mm-download)

And then email me eric.pleiss@techdata.com, and I will activate the functionality for you.