Report last execution date/time from cognos content store tables.

[sureshgv1234]

Hi Gurus,

I have one requirement (i.e) I want to display report last execution date/time from Cognos content store tables.

I don't want from audit tables i need only from content store tables.

Moreover, i have one more In the case of a Report View - can we know the source Report that the View is linked to which report.

Thanks,
Suresh

[Andrew Weiss]

sureshgv1234,

MetaManager's Content Documenter documents ReportViews and the information that you're looking for.  Specifically the history information is documented from the Content Store Report Versions and not from the Audit Database (although it can document audit database history too).

I've attached an example report, but you can download the MetaManager Trial and try this for your self.  Just select some Report Version objects and choose "History" from the General category.

Thanks,
-Andy