query to get List of Reports in BOXI 4.1

Question

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. I dont see BO_AUDIT database in my environment. BOXI version is 4.1 SP3

Answer 1

Former Member Answered Nov 29, 2017 at 07:32 AM

0

Hi Sheik,

You need to run query in Admin tools ie. Query Builder.

To access Admin tool:- http://hostname:(port of Web Application server)/AdminTools Eg. http://hostname:8080/AdminTools

Login with Default Enterprise Administrator user and run the following query:-

Select * from CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS where SI_Kind='CRYSTALREPORTS'

Find Questions & Answers