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!
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
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 :-)