IBM Business Analytics

I'm looking for a method to retrieve the following from the Content Store or Audit DB for a given search path:

• Report name
• Report path
• Report owner ID
• User ID who ran report
• Report execution date
• Report execution details - was the report run interactively, saved to content store, saved to file system or emailed.

Any advice appreciated.

You'll want to query your logging/audit database, joining the cogipf_runreport and user_session tables along cogip_sessionid to get the bulk of what you are looking for.  The report execution details are in the cogipf_action table -- you can join that with the cogipf_runreport/cogipf_usersession tables to get the results you are looking for.

Hi @Dax Lawless. 

It took me a while to get back to this. Thanks for your input - the information was helpful. I am now able to find 

• Report name
• Report path
• User ID who ran report
• Report execution date 
• Operation 
• Target type

What I haven't been able to find is the information on if the report was saved to the content store, file system or emailed and in what format (PDF, Excel).