Hi All, i am trying to build a report showing all un-used reports(reports which did not ran). I came across belpow query which will give me list of all reports exist on content store. Having this i will use audit(run reports query subject) to find difference.
But query i am using to hit content store is throwing error as i am not able to find CMOBJNAMES_BASE table in my content store database. other two tables ( CMOBJECTS ,CMCLASSES) are available. Can you please suggest what is causing this plus any other way to achieve same result. My content store database is DB2
SELECT n.cmid,
o.pcmid,
n.name AS REPORT_NAME,
o.version,
o.disabled,
c.name AS TYPE,
FROM CMOBJNAMES_BASE n, CMOBJECTS o, CMCLASSES c
WHERE n.cmid = o.cmid
AND o.classid IN (0, 1, 10, 18, 19, 33, 81, 82)
AND o.classid = c.classid
AND n.isdefault = 1
AND c.name = 'reportView';
anyone who can help me in achieving the same..
Which version of Cognos are You running?
And the version of Your logging store ?
SELECT * FROM COGIPF_SYSPROPS
Version :
v.10.2.1 FP8