COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Ammus1234 on 20 Oct 2016 12:14:19 AM

Title: Get reports and associated access groups
Post by: Ammus1234 on 20 Oct 2016 12:14:19 AM
Hello All,

Is it possible to get the report names and the associated cognos groups for which they have access to the report from content store?

Any inputs will be appreciated.

Thanks in advance
Title: Re: Get reports and associated access groups
Post by: Eric.Pleiss on 20 Oct 2016 09:44:24 AM
Ammus,
This task can be completed a couple of different ways using Avnet BSP's MetaManagerâ„¢.  Using the Security Audit tool you can see the complete security lineage for a user, including groups and rolls, as well as any direct or indirect access to objects in the content store, all the way down to the report level. 

(https://i.imgsafe.org/8cec79c056.png)   (https://i.imgsafe.org/8cec142c19.png)

Additionally, we can obtain documentation related to the content store access with the Canned Reports "Account Security Audit", giving a complete documentation of user security, groups and roles, and direct and indirect access down to the report level.  This report can be generated in a variety of formants, PDF, Excel, XML.  I've included a screen shot of the PDF export for user Alfredo here.

(https://i.imgsafe.org/8d238404ef.png)

For more information, see http://www.bspsoftware.com/products/metamanager/ (http://www.bspsoftware.com/products/metamanager/), and give it a try on your own environment.