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.
Thank you.
Thank you.
- Hi Mush,
Even you can see in CMS history as well for the particular report, the following information you will get: Start time,End Time, Duration....etc.
Regards,
Abhishek Jain
- 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.- Thank you both. I took a quick look at the tables and think that they will work. Thanks again.
Martti K.