Which reports are using specific Database

[Former Member]

Is there a way to find out which reports(crystal) in BOBIP 4.0 are using a specific datbase server?

Server Name is changing, and we need to identify which reports will need to be updated.

[Former Member]

Try the below query in Query builder... Update the "DSN Conection Name" with the connection name which you have in your environment to fetch all the reports running against that specific database server.

Select SI_NAME from CI_INFOOBJECTS where SI_PROCESSINFO.SI_LOGON_INFO.SI_LOGON1.SI_SERVER = '<<DSN Connection Name>>' and SI_INSTANCE = 0

Also, you can use Realtionship queries in CMC to fetch all the reports using the specific connection.

[Former Member]

Hello  Abdul,

Please try below query in BO Query Builder and see if it meets your requirement:

• To get list of Crystal reports by data connection from BO Enterprise:

SELECT SI_NAME FROM CI_APPOBJECTS WHERE SI_KIND=’MetaData.DataConnection’

-Mahesh