CI_OBJECTS

[BScentral]

I am currently trying to create a report in CR9 that will let us know what reports we have on CMC and their name. We are using CE 9 with CR 9. I was told that you could do this by using CI_OBJECTS, but I can't find this on our database. Our database is on a MS SQL Server 7.
Thanks in advance.

 

[chris777]

I think you can get what you want from a direct connection to the CE database. In the CE9 database is the APS_InfoObjects table. If your system database has been uninstalled/reinstalled, it may have a number appended to the name, like: APS_InfoObjects2. The ObjName will give you the Report Names if you specify a TypeID of 2 in the select expert. If you want the folders also, they are a TypeID of 1 and the reports are linked to them by the ParentID field.

Most of the fields are Binary data and are useless to report from. However, you should be able to retrieve a simple report list using these fields.







Chris
Data Intelligence Group

http://www.digus.com

 

[BScentral]

Thanks so much for your reply. It helped alot.