Determining who is logged on and which reports are running on BOE 11

[Former Member]

Post Author: staffoto

CA Forum: Administration

Running BOE 11. Is there a way to determine who is logged on to InfoView?Is there a way to determine which reports are currently running? Thank you.

[Former Member]

Post Author: jsanzone

CA Forum: Administration

Raymond,

Matt was giving the SQL statement that you would enter when using the query builder (QB). Here is the URL entry you would put into your browser address: /businessobjects/enterprise115/WebTools/websamples/query/logonform.aspx?framework=&page=current"&gt;https://<server>/businessobjects/enterprise115/WebTools/websamples/query/logonform.aspx?framework=&page=current

Once you hit this site you'll be prompted for the administrator credentials. After passing through the login formalities you'll be presented with an open area where you can type in your SQL statement. At this point copy and paste Matt's suggested statement...

[Former Member]

Post Author: rkelly@micros.com

CA Forum: Administration

Matt.

Could you elaborate on this?

I understand what the SQL Statement is doing but I don't know where to enter this.

I use TOAD as my SQL Editor. What database do I point this to?

Do I have to enter this SQL as a command in a Crystal Report?

Please advise.

Raymond

[Former Member]

Post Author: fiddelm3742

CA Forum: Administration

To view which reports are currently running use the following:

select SI_ID,SI_NAME, SI_DESCRIPTION from CI_INFOOBJECTS where SI_SCHEDULE_STATUS = 0

you can select whatever you like I just included the Object ID, name, and whatever description is available. Run that via Query Builder, or build an app that utilizes the SDK and run it in that manner.

As for who's logged into Infoview, I'm not sure if there is a query that can do that, either that or i haven't figured it out yet.