Skip to Content
0
Former Member
Jul 02, 2009 at 08:24 PM

Get the list of reports and their ODBC details

64 Views

Hi :

We have around 20,000 objects hosted on our BOXI R2 SP3 environment. May be around 17000 of these are reports. I have a few questions >>

1. Is their a way to get the list of all the reports and their ODBC details. I tried running the following query 'Select Top 20000 SI_ID, SI_NAME, SI_PROCESSINFO.SI_LOGON_INFO From CI_INFOOBJECTS Where SI_PROGID = 'CrystalEnterprise.Report' and SI_INSTANCE = 'False'' in the query builder. But it times out.

2. Will running this query using the sdk affect the stability of the environment.

3. Is there a way to spilt the query into 4-5 batches to get 3000-4000 records at a time.

4. Can we get the min(SI_ID) and max(SI_ID), how ?

Regards,

Abhijit Sanas