Hi,

I want to fetch list of all Reports/Dashboards along with groups/roles that has permission to view the report.

Can someone help me with the Content store tables/ query to fetch these result set.

Thanks,

Vaibhav

I do not know how to do it though the database tables.  

MetaManager can get you this information by searching for //report in the search bar and documenting the account security.  You can see who has direct vs indirect access and direct vs indirect memberships to those reports or any object you want to drag and drop over in the Content Documenter UI.  You can export those result to Excel for easy filtering and sorting or go with a simple PDF or even a database export.  And if brave enough a Cognos Analytics report can be built off that database.  :)  

I know how to get a list of reports and probably dashboards (we don't use them). I thought that the only way to prevent someone who could view report1 from viewing report2 was through folder permissions. And maybe it wasn't view, maybe it was edit. Didn't think individual reports had permissions. 

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

Hi,

There is no way to do using SQL in Content Store, because the table field that stores this information is serialized, not plain text.

But you can do using Cognos SDK.

Just in case you are still looking for a solution, you can try this sample tool to query the content store via SDK - QueryCAtool.

Because the REST API is only using the object ID and not a serachPath I created a simple query tool to get the storeID value of an object, and also some other information like the permission (policies).

The script is based on the trigger script that is provided by IBM (newer version from IBM Accelerator Catalog).

You find the QueryCAtool (as-is and without any warranty) in folder ICALT-3.x of  https://ibm.box.com/v/ICALT-Public-Information 

You only need to adjust the path for variable JAVA_HOME and LIBS_SDK in the script file QueryCAtool.sh