im working on a project that needs to build a report catalogue for all our reports in Cognos. I have recently gained access to Cognos Content Store (SQl server database) so have been going through the tables.. luckily i found this thread :)

The sql script posted by Micheal Singer works for our version of Cognos (v 7.7) but i just wanted to ask what exactly does the 'active =1' in the where clause mean as i was looking at a different flag for active status in the CMOBJECTS table ..

where disabled = 0 or disabled is null (to get active records)

Alos i saw mention of getting column names of each report via xml but doesnt the CMOBJPROOPS13 table give a list of all parameters / column names used in each report and the order?

I need to get the number of times each report was run, who ran it, what source its connected to, and any other pertinent information so that we can assess which reports will be nigrated to a new system. Any pointers for tables to use for this would be greatly appraciated. Is there any documentation for the available tables in content store? i cant seem to find any online (a lot of broken links).

fyi this is the sql script posted by Micahael Singer that works for us in cognos 7.7..

select ob2.cmid, c.name as classname, n.name as objectname, o.DELIVOPTIONS as 
deliveryoptions, z2.name as owner
from CMOBJPROPS2 p
inner join CMOBJPROPS26 o on p.cmid=o.cmid
inner join CMOBJECTS ob on ob.cmid=o.cmid
inner join CMOBJECTS ob2 on ob.pcmid=ob2.cmid
inner join CMOBJNAMES n on n.cmid=ob2.cmid
inner join CMCLASSES c on ob2.classid=c.classid
left join CMREFNOORD2 z1 on z1.cmid = p.cmid
left join CMOBJPROPS33 z2 on z2.CMID = z1.REFCMID
where ACTIVE = 1 order by z2.name, objectName