Reports without Universe as a connection

[Former Member]

Hello All -- I have a request to retrive all reports which does not use universe as a connection and uses freehand sql directly to fetch details from database from reports itself. Please let me how i can achieve this in  BO XI 3.1 Query Builder

[former_member182521]

Can you try this and let me know how it goes

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='FullClient' AND SI_UNIVERSE.SI_TOTAL=0

[Former Member]

Hello Manikandan

Thanks for your reply. I have already executed the same script from one of your answers of previous disuccsion forum. But this command gives reports which is using universe as a connection too.

[former_member182521]

There could be few reports that are using universe but those reports are Orphan reports which losts their binding with corresponding universes.