cancel
Showing results for 
Search instead for 
Did you mean: 

Query Builder for BI 4.2

former_member586792
Discoverer
0 Kudos

Query builder for BI 4.2 :

How to get a list of scheduled reports and documents those are in public folders including Sub folders based on one universe

thanks to explain me the synthax

Best regard,

denis_konovalov
Active Contributor
0 Kudos

Have you tried searching ?
I think this was asked/answered before.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185603
Active Contributor
0 Kudos

Try this

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>'") and SI_RECURRING=1