COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Bandit69330 on 07 Dec 2015 04:52:23 AM

Title: Reporting on security deployed on folders
Post by: Bandit69330 on 07 Dec 2015 04:52:23 AM
Hi all,

My CEO asked me for a report which will show the security deployed on the folders of our portal...
I've searched for these informations in the content store without success...  :(

I need your help ! Is there someone who could say how and where I can retrieve these datas ?

Thanks for your help !
Title: Re: Reporting on security deployed on folders
Post by: mcc.chernandez on 07 Dec 2015 12:32:28 PM
You need to create a report that shows permissions for every folder? There is some information here if you want to do yourself: http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos-l/how-to-get-how-many-users-are-having-permission-to-the-reports-from-content-store-5401408

It does not appear to be complete but may get you started.

Motio also has a tool that can help: http://info.motio.com/Blog/bid/103917/How-to-Find-Permissions-on-Folders-Packages-etc-in-Cognos

Edit: looks like the Audit Extension package may also help: http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html?ca=drs-
Title: Re: Reporting on security deployed on folders
Post by: Bandit69330 on 08 Dec 2015 02:39:28 AM
Thanks for yor response MCC, thats will be a good beginning for my reflection on this report !!
Title: Re: Reporting on security deployed on folders
Post by: Andrew Weiss on 12 Dec 2015 09:00:51 AM
Bandit

Metamanager has a module called security auditor that audits the entire content store and produces the exact report that your looking for. There's a demonstration of how we accomplish this here : http://www.bspsoftware.com/sorting-ibm-cognos-security-using-metamanager/

And you can download metamanager for free and try it for yourself here:

http://www.bspsoftware.com/products/metamanager/

Thanks
Andy


Sent from my iPhone using Tapatalk
Title: Re: Reporting on security deployed on folders
Post by: Bandit69330 on 14 Dec 2015 02:46:25 AM
Thanks Andrew !! I will try Metamanager today !
regards
Bandit