no. of scheduled reports against a universe

[system]

HI busobj forum gurus,

I need to know Is there a way to find no. of scheduled reports against a universe from both public and personal folders.

Thanks,
Kumar.

---

pkkumar (BOB member since 2012-07-06)

[system]

try this
Example CMS Queries:

Select only Crystal Reports and Web Intelligence reports within the Public Folder Hierarchy, excluding report instances

SELECT * FROM CI_INFOOBJECTS WHERE DESCENDENTS(“SI_NAME=’Folder Hierarchy’”, “SI_ID=23&#8243 AND SI_KIND IN (‘CrystalReport’, ‘WebI’) AND SI_INSTANCE = 0

---

kch (BOB member since 2005-04-08)

[Hope]

pkkumar:
what version of BO are you on?

KCH:
Can you provide which objects we need to pull in for BO4.0 aud universe.

[system]

me on BO 4.1 sp3;
The querying is on the repository database.

---

kch (BOB member since 2005-04-08)