Clarity

  • 1.  Reports on Reports

    Posted Jan 24, 2012 04:35 PM
    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.


  • 2.  RE: Reports on Reports

    Posted Jan 24, 2012 05:03 PM
    If they are launched from Clarity they should appear with other "jobs" in cmn_sch_job_runs table.

    Martti K.


  • 3.  RE: Reports on Reports

    Posted Jan 25, 2012 02:03 AM
    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


  • 4.  RE: Reports on Reports

    Posted Jan 25, 2012 03:48 AM
    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.


  • 5.  RE: Reports on Reports

    Posted Jan 25, 2012 02:10 PM
    Thank you both. I took a quick look at the tables and think that they will work. Thanks again.