CA Service Management

  • Private Community

  • 1.  BOXI Report details

    Posted Jan 13, 2017 05:24 AM

    Hi,

     

    I would like to get list of scheduled and non-scheduled reports list along with last run date time in BOXI.

     

    please let me know if we can take it from BO_CMS database.



  • 2.  Re: BOXI Report details

    Broadcom Employee
    Posted Jan 13, 2017 01:46 PM

    The CMS database schema is different based on the version of CABI/BOXI installed.

     

    What version of CABI/BOXI do you have installed?



  • 3.  Re: BOXI Report details

    Posted Jan 13, 2017 01:47 PM

    Boxi version is 4.1 sp 3

     

    On 14-Jan-2017 12:16 AM, "Paul_Coccimiglio" <



  • 4.  Re: BOXI Report details

    Broadcom Employee
    Posted Jan 13, 2017 01:55 PM

    Following query will show all scheduled reports

     

    Select si_id,si_name,si_schedule_status from ci_infoobjects where si_instance=1



  • 5.  Re: BOXI Report details

    Posted Jan 13, 2017 02:04 PM

    Hi,

     

    I dont see such tables in bo_cms database. Am able to see only cms_

    infoobjects6 table.

     

    On 14-Jan-2017 12:25 AM, "Paul_Coccimiglio" <



  • 6.  Re: BOXI Report details

    Posted Jan 13, 2017 02:22 PM

    Hi,

     

    Thanks for help. am able to submit above query through query builder. is there any other option to get last run date time for all reports which is not scheduled. please help.