Content Store query to fetch permissions of an object

[Ravisha]

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

[Eric.Pleiss]

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

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