Query to find all WEBI active users

sdk development
1

Basicallly I am looking for a query to find all the users who are currently writing or refreshing WEBI reports. I have both “report consumer group” and “report writer group” in the system. Please do not publish any query here without testing. I tested the following query (extract all the users from specific user group) in query builder but does not work:

SELECT SI_ID, SI_NAME, SI_KIND, SI_USERGROUPS FROM CI_SYSTEMOBJECTS
WHERE DESCENDANTS(“SI_NAME=’USERGROUP-USER’”, “SI_NAME=’ADMINISTRATORS’”)

We use BO 4.2 SP2 FP6.

Thanks in advance!

KUA (BOB member since 2007-12-09)

2

That information is not available via a CMS query. You can use the WebiAdminTool to extract some data from the active WebI servers, which would include the owner of actions that are being executed.

joepeters :us: (BOB member since 2002-08-29)