Hello,
I'm trying to extract a report with all querys (not only the top querys) for a specific user in a specific date.
There is a custom report or query for this?
Thanks for your attention.
What flavor is your repository (Oracle, SQL Server, or MySQL)?
Sorry, SQL Server.
Looking for the any same .... any ideas, pointers, clues?
This can be done via custom reports, which are available on thwack.com under the Database Performance Analyzer. Here is the link that should do this if you have a SQL Server repo: Custom Report - Top SQL for Database User. If you have an Oracle repo here is the link: Custom Report - Top SQL by Database User. HTH. Note that these are executed outside of DPA at this point.