query to get instance of a report

[system]

Hi All,

Can someone share the code for getting instance of a report? I know
you have to query the CI_INFOBJECT table.

Thanks,
hena

---

hena (BOB member since 2010-08-17)

[system]

Check this thread.

XIR2 Query Builder Admin Reports

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 report…

---

Arjun (BOB member since 2008-07-28)