Find what webis use certain connection

[victortorreblanca]

Dear BO Experts,

I'm playing around building a Webi pulling data from the Universes "BI platform CMS system database" and "BI Platform Audit Analysis" but I can't find what I need.

I need to find all the webis from my BO Platform which have any Query that use a connection called ABC_123

Do you know in what universe and objects shall I use in order to see that?

Thanks!

Victor Torreblanca

[victortorreblanca · Accepted solution]

I managed using the Query Builder

If the URL for your BO Launchpad is something like http://BlahBlahBlah/BOE/BI you can try http://blahblahblah/AdminTools/querybuilder/ie.jsp

select * from CI_INFOOBJECTS where SI_WEBI_DOC_PROPERTIES like '%XXXX%'