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).
------------------------------
David
------------------------------
Original Message:
Sent: Wed May 08, 2024 09:39 AM
From: Dax Lawless
Subject: Run history details for reports
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.
------------------------------
Dax Lawless
Original Message:
Sent: Tue May 07, 2024 05:00 PM
From: David Hill
Subject: Run history details for reports
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.
------------------------------
David
------------------------------