Tracking user info for Deski Report

building reports desktopintelligence
1

Hi BO Experts,

We have some reports that are taking a very long time to run and want to identify who is running it. The team which monitors database identified these are BO reports but are unable to track further information. This is creating a major problem.
So we categorized the reports into Universe based and Free hand SQL DeskI reports

  1. Universe based: We used END_SQL parameter to append BOUSER and Document name as comment to any query formed from the universe.
  2. Free hand SQL: This is where we are clueless. Not sure how to track it. The Free hand SQL can be local reports on users machine, and it would have been done ages ago. So there is no way to track who all are having these reports. Is it possible to add some info at higher level which would help us to track the user who is running a free-hand SQL report.
    The database used here is Sybase and BO version is 3.1

The only other alternative is to change the password, which we don’t want to do as this would create bigger problem.

Any advice on this matter will be very helpful.
Thanks in advance

bo_greenhorn (BOB member since 2007-05-03)

2

Hi,

Unfortunately, there is nothing that you can do with free-hand SQL reports :nonod:

In Oracle database, a DBA can find out the name of the machine from where the query is hitting the database. Can anything like that be found out also in Sybase?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thank you Marek,

Thats exactly what I was afraid of :cry:

Currently they are able to get the IP but input I received was that it did not help. Not sure about the setup

I was hoping there was something which would forcefully add to query the user name like END_SQL parameter did.
Thank you once again for your help.

Jerry

bo_greenhorn (BOB member since 2007-05-03)

4

Hi

I am new to this forum and BO.
Can you Please let me know how to identify Free Hand SQL based reports?

Thanks In advance
Neha

njaiswal (BOB member since 2010-05-07)

5

Hi Neha,
You asked the same question here:

So please do not fragment the discussion and continue to solve the problem only in your original topic.

Thanks.

Marek Chladny :slovakia: (BOB member since 2003-11-27)