Skip to Content
author's profile photo Former Member
Former Member

How to find users name who is running report on top of query?

Hi

We have many queries built on top of Info Provider, now i need to find which query is in use. It seems most of these queries are for test purposes.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Nov 28, 2013 at 11:19 AM

    HI,

    I think table RSDDSTAT_OLAP may help you in finding the relevant information.

    Enter the Query technical name in OBJNAME field and execute--UNAME field give the name of the user who executes the query.

    Hope this helps.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2013 at 11:32 AM

    Hi Pawan,

    Table : RSZCOMPDIR will give you all details

    Here TSTPNM,wiil give you that Information.

    Regards,
    Seshu.P

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2013 at 11:46 AM

    Hi Pawan,

    There different ways you can find perticular query is used by user or not.

    1)BW statastics standard providers 0BWTC_C10 if installed

    2)Table RSDDSTAT

    3)AL's option

    4)seshu's option etc..

    Hope it will help.

    Regards,

    Ganesh Bothe

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 29, 2013 at 04:19 AM

    Hi pawan,

    please install the statistics cube 0TCT_C01 and load.

    it will provide how many user running reports and how many times they used reports.

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2014 at 05:23 PM

    Please close the thread if your issue was resolved.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.