This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

list of Queries for specific DB

Hello,

I would like to know if it is possible with DPA to obtain the list of queries which have been executed on an SQL database within a defined period of time? I saw "Find SQL", but I am missing the chronology of events.

Thank you

Parents
  • As mentioned here, I think a custom report is your best bet.

    • Click into reports
    • select "Top SQLs" as the report type
    • Select "User-Defined SQL Statements"
    • Click the Add button
    • Type in the identifying SQL text like "insert into nodes" or whatever you are looking for
    • Search - and make sure you are searching SQL Text option if that is how you are finding these
    • Select all that apply (like maybe all of them) and click OK
    • Click OK again
    • Set your time frame (Date Range)
    • Then click on Display Report
    • You can also show all SQL Text at the bottom of the report as well

    HTH!

Reply
  • As mentioned here, I think a custom report is your best bet.

    • Click into reports
    • select "Top SQLs" as the report type
    • Select "User-Defined SQL Statements"
    • Click the Add button
    • Type in the identifying SQL text like "insert into nodes" or whatever you are looking for
    • Search - and make sure you are searching SQL Text option if that is how you are finding these
    • Select all that apply (like maybe all of them) and click OK
    • Click OK again
    • Set your time frame (Date Range)
    • Then click on Display Report
    • You can also show all SQL Text at the bottom of the report as well

    HTH!

Children
No Data