Hi all,
I am using an older version (Cognos 7).
Managers have requested an automated report each month that
details the security access for their users and groups. They want reports
showing Powerplay and Reportnet 1.1 users (preferably all on one report).
Is there a way that I can automate this process? Can I build a script or something to do it?
Thanks,
CGW
Sure, you can use a combination of scripting and utilities, to extract it as XML. The you can process it anyway you want. There are also commercial utilities available on the market that manage and document security among other things.
To query the content store in order to extract this information really requires the SDK, or as the previous posts states, a 3rd party product. There are a few products that document the content store security, as well as allow you to maintain and modify security on your objects one at a time or in mass.
Take a look at the Powered by Cognos website via Cognos's website for products that can do this. http://www.cognos.com/solutions/powered_by_cognos/brightstar_partners.html (http://www.cognos.com/solutions/powered_by_cognos/brightstar_partners.html). The site is a little dated, as there are a lot of new features available, but you can get to the product website from there.