Content STore tables

[mrcool]

Hi All,

I am looking for content store tables which have information of folder names, user names and their roles and their access to all the folders.

Any help would be highly appreciated.

Thanks,
MC

[simon.hodgkiss]

Hi,

Suraj Neupane gives a good rundown and link to info on Content Store tables in another Cognoise Thread:

http://www.cognoise.com/index.php/topic,17411.msg50409.html#msg50409

Though if you're looking to audit security\permissions applied in an environment there are some tools which can help you do that:

BSP's MetaManager product has the "Security Auditor" feature which will do this for you:
http://www.bspsoftware.com/Products/MetaManager/Secure

And (I feel bad putting this on a BSP powered forum) MotioPI also purports to do this:
http://info.motio.com/Blog/bid/75179/Document-Cognos-User-Security

And of course there's Cognos Audit Extensions:
http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html



Hope this gives you somewhere to start.

Simon

[Grim]

And of course there's Cognos Audit Extensions:
http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html

As of Cognos 10 the extensions are garbage. Your better off with:
Content Sizer and Browser tools
https://www.ibm.com/developerworks/data/library/techarticle/dm-0808masters/

[mrcool]

Thank you all for your inputs.. I will have a look into the links. I am trying to build a report with the requested information hence I requested for exact tables.

Thanks,
MC

[mrcool]

Hi Grim,

CM browser tool doesn't provide the information I want. I would like to create a report with all the user names, their roles and folders they have access to.
What content store tables has these information?I have found table for users and folder names but how to get roles of the user and permissions on the folders.

Thanks,
MC