List of reports connected to .UNX Universe

[Former Member]

Hi,

Please provide me the query for extracting list of reports connected to .unx universe in Query Builder.

I tried the query

SELECT * FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHERE PARENTS("SI_NAME='WEBI-UNIVERSE'","SI_NAME =’EFASHION’")

But that didn't work with .unx universe.

Thanks in advance.

Venkat

[former_member185603 · Accepted solution]

Use this query for UNX universe.

SELECT SI_ID, SI_NAME, SI_UNIVERSE, SI_DSL_UNIVERSE, SI_SL_DOCUMENTS, SI_SPECIFIC_KIND, SI_OWNER, SI_LAST_RUN_TIME FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS Where PARENTS ("SI_NAME = 'Document-DSL.Universe'", "SI_NAME = '<UNX Universe Name>'")

[Former Member · Accepted solution]

Hi Jawahar,

Thank you for your quick response. That was the query I was looking for.

Venkat