COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Content Explorer - Portal => Topic started by: irishrich on 03 Sep 2020 01:31:35 PM

Title: IBM Cognos Analytics 11.0.7 oracle tables
Post by: irishrich on 03 Sep 2020 01:31:35 PM
I need to retrieve the last time a specific list of reports was opened and/or run. I have a list of 136 reports. The report list I have is because I am removing a field from Framework Manager and need to email out a list of reports that are affected, but many of the reports are probably ad hocs/not used.etc. I want a recent list of reports.
I am looking at the tables/views in the Oracle database, but I am not sure which to use and how. Any insight or information would be appreciated. Thank you.