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.
The CMS database schema is different based on the version of CABI/BOXI installed.
What version of CABI/BOXI do you have installed?
Boxi version is 4.1 sp 3
On 14-Jan-2017 12:16 AM, "Paul_Coccimiglio" <
Following query will show all scheduled reports
Select si_id,si_name,si_schedule_status from ci_infoobjects where si_instance=1
I dont see such tables in bo_cms database. Am able to see only cms_
On 14-Jan-2017 12:25 AM, "Paul_Coccimiglio" <
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.
Retrieving data ...