Need list of reports with associated Uni from CMS repository

[system]

I need to collect list of reports in our system and associated universes if possible.

Is there any limit on number of rows return by query in AdminTool.

When i used below query, i am getting only 1000 rows

Select SI_NAME from ci_infoobjects where si_kind in (‘Webi’)

But when i query for count, i am getting around 7500

Select Count(SI_ID) from ci_infoobjects where si_kind in (‘Webi’)

Does any body have any idea? Any solution for collecting metadata about repository?

Any help would be greatly appreciated.

---

MightyBO (BOB member since 2007-06-28)

[system]

This Excel utility with several lists from the downloads section is a more suitable option.

Also: SELECT top 64000 etc for the query tool
… but be careful as to the size as you can wait ages for everything and then trying to screenscrape this into excel etc causes page hangs - so use ranges or filter the result set.

---

MikeD (BOB member since 2002-06-18)