query to get List of Reports in BOXI 4.1

[Former Member]

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

[Former Member]

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'

Please let me know in case of anything.

Regards,

AniketVN