Logging user queries in BO 5.1.5 and Oracle 9i

[infaddict]

Hi, is it possible to automatically log queries ran by each user in Business Objects version 5.1.5 (back-end database is Oracle 9i)?

For example, I need to know which user has run which queries (e.g. the SQL) and ideally how long the query took (elapsed time)?

Any help much appreciated.

Regards,

infaddict

 

[skrandel]

Are you talking about the BO full-client?

You have 2 options. Figure out how to make the database itself do the logging. Buy a 3rd party product that does this.

The problem you're going to have is that you are now 3 major releases old. It's likely that the 3rd parties (Version Manager from EBI Experts comes to mind) will want to deal with anything on V5.

Steve Krandel
Intuit

 

[infaddict]

Yes, the users have the full BO client installed and can create their own custom queries. I would like to know which users are doing which queries and how long they are taking. This is to investigate performance issues and to identify heavy usage users.

We will be upgrading to a later version as part of a data center move, but that is not until much later in the year.

So I guess you are saying we either write our own software to store this information each time a user does a query (how hard is this to do?).. or we buy and install a product to do this for us.

Thanks for the advice so far.

 

[skrandel]

BO client activity is not logged. You'll need a strong understanding of VBA and the BO object model.

Just as an FYI - BO will never log full-client activity. It can be logged if using 3-tier but not until XI R3. It was there in 6.x, but was removed in XI R2.

The only company I know of that ever did this was the one I mentioned earlier.

Steve Krandel
Intuit