That’s actually very close to what I was looking for. Thanks!
It’s still very limited 'cos I’m still on R2 and if I limit to “Failed” instances, it shows me ALL the failed instances that we’ve ever had, while I just want the latest. And there’s no way of sorting it by date. So in that way, it’s very limited.
But thank you anyway! Very helpful for other things.
Your other option would be the Query Builder (also in the admin launchpad). With that you could query for just Webi instances and throw in an ORDERBY si_starttime. There are quite a few samples on using the InfoStore query language on these forums. Such as :
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…
JGregwww.zoom-software.com
JGreg (BOB member since 2007-11-21)