Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: sureshgv1234 on 22 Apr 2015 07:44:34 AM

Title: Report last execution date/time from cognos content store tables.
Post by: sureshgv1234 on 22 Apr 2015 07:44:34 AM
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
Title: Re: Report last execution date/time from cognos content store tables.
Post by: Andrew Weiss on 22 May 2015 01:40:18 PM
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
Text only | Text with Images