Is there a code or anything from which we can extract all the universe names along with their connection parameters.
thanks in advance
cooldude (BOB member since 2007-10-03)
You could use the Query Builder, something like
Select * From CI_APPOBJECTS Where SI_KIND = 'Universe' Order By SI_NAMEwould give you a start
kedge (BOB member since 2007-02-14)
Does any one have solution for this?..Can we pull all the connection names and associated universe names with SDK or query builder or VBA…
cooldude (BOB member since 2007-10-03)
Yes, you can get this information via the SDK. Look at the web services SDK it has methods for getting the universes and connections.
jwhite9 
(BOB member since 2006-07-28)
Another option is to use the COM-based Designer SDK. There was a session on this at the conference this year.
-Dell
hilfy (BOB member since 2007-04-16)
Hi,
You cannot use the query builder for this because you need two queries. The only solution is to use the CMS sdk or the Designer one.
Regards
Sebastien
The query builder suggestion was just to give an idea that the data is readilly available.
Have a look here
Does this give what you’re after?
kedge (BOB member since 2007-02-14)