Is there a way to get reports on recent report activity? That is, which reports have been run, by whom, and how long they took to run? We are using Business Objects, on a separate server, and are running Clairty V12.
Yep CMN_SCH_JOB_RUNS contains the run details (and CMN_SCH_JOBS / CMN_SCH_JOB_DEFINITIONS the details of what was job/report was run).
You can also get the user parameter information from CMN_SCH_JOB_RUN_PARAMS if you need it.
The info gets "tidied up" of CMN_SCH_JOBS_RUNS (depending on your system housekeeping settings); so you might like to archive off the report dataerm statistics/analysis / summary of the report data as a regular interval if you are trying to keep long-term statistics/analysis over your report usage.
Martti K.