Count of WEBI reports in repository

[system]

Hello Experts,

i want to get the count of WEBI reports in our repository, i tried in querybuilder but the below query hangs.

SELECT COUNT(SI_ID) FROM CI_INFOOBJECTS WHERE SI_KIND=‘WEBI’
I am not sure whether it is valid one or not.

i tried to get the number by running the query against to REPOSITORY using below query.
SELECT COUNT(OBJECTID) FROM CMS_INFOOBJECTS5 WHERE TYPEID=260, this is also not giving exact figure.

Need your help…

regards,
Leong.

---

Leong BO XI (BOB member since 2007-08-09)

[system]

Leong,

marklee (a contributor to BOB) shared a view he developed to query the Repository. Please following this posting: https://bobj-board.org/t/124272
Thanks,
John

---

jsanzone (BOB member since 2006-09-12)