cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Report or query for extract the querys for a specific user and specific date

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.

Labels (1)
0 Kudos
4 Replies
Level 7

Looking for the any same .... any ideas, pointers, clues?

0 Kudos

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.

0 Kudos
Level 14

What flavor is your repository (Oracle, SQL Server, or MySQL)?

0 Kudos

Sorry, SQL Server.

0 Kudos