title: How to access database behind Cognos Connection (10.2)
body: <p>We are using Cognos Connection as a web interface to create/manage Cognos reports via a connection to an Oracle database.  We have some reports that are saved to the file system (which I believe means the file system on the server in which Cognos is hosted) and other reports that are distributed via email.   </p>
  
  <p>We have unplanned (due to unforeseen circumstances) and planned (due to upgrades, maintenance, deployments, etc..) outages pretty frequently and this causes some Cognos reports to not run.  For the reports saved on the file system, we have a view in our Oracle database that shows the last updated date for these reports and stores them in  blob format (I'm not sure how they get from the Cognos file system to our Oracle database, but I'll have to figure that one out later).  I've created a couple of views to check the last updated date based on the scheduled frequency of the reports (based on a static schedules table I created) and this will give us a quick view of which reports need to be manually ran and saved (due to not running during an outage).  </p>
  
  <p>That said, I'm having trouble figuring out how to get the status of reports that aren't saved in the file system and are just emailed to users.  I've noticed that their is a run log/run history for each report and I can view the details of each day's log to see if there were issues; however, it's too cumbersome to check 50+ reports manually everyday.  Is there a way that I can access the database behind Cognos Connection (where these logs are stored) in order to view this information?  For instance, could I create a DB Link from our Oracle database to write queries on the objects behind Cognos?  If not, is there a different way to get this information in some sort of automated or mass data pull format?</p>
  
  <p>Any and all insight/guidance/tips are greatly appreciated.</p>