Modified Date in Cognos Connection

[gatorfe]

Hello,  I am trying to find out how many reports have been modified this year so looking for the Modified Date field I see in Cognos Connection.  Does anyone the where this is stored in the Audit db?  Thanks in advance for any suggestions!

[ahmerzaidi]

This article might help.  I came across this a couple months ago and bookmarked it for when I needed it.

http://bi-framework.blogspot.com/2009/03/automated-cognos-report-documentation.html

[wyconian]

Hi

I've just been doing something similar try something like this

SELECT T3.NAME OBJECT_TYPE,
             T1.NAME OBJ_NAME,
             T2.MODIFIED DATE_MODIFIED
FROM CMOBJNAMES T1
         JOIN CMOBJECTS T2
           ON T1.CMID = T2.CMID
         JOIN CMCLASSES T3
           ON T3.CLASSID = T2.CLASSID
WHERE T3.CLASSID = 10

This is filtered for reports, change the classid for other objects

Good Luck :-)