query to get instance of a report

[system]

Check this thread.

120×120 10.4 KB

I have compiled a list of queries that will get some basic information out of the CMC. I’m trying to figure out how to run more complex queires to get all the reports that I need. here is the initial list. feel free to add queries… Thanks Get All Webi reports Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID=‘CrystalEnterprise.Webi’ And SI_INSTANCE=0 Get Full Client Reports SELECT SI_ID, SI_NAME,SI_FILES FROM CI_INFOOBJECTS WHERE SI_KIND in( ‘webi’ ,‘FullClient’) Get All reports S…

---

Arjun (BOB member since 2008-07-28)