un-used reports (missing one table CMOBJNAMES_BASE)

[nsaxena]

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';

[nsaxena]

anyone who can help me in achieving the same..

[khanberg]

Which version of Cognos are You running?

And the version of Your logging store ?
SELECT *  FROM COGIPF_SYSPROPS

[nsaxena]

Version :
v.10.2.1 FP8