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

How to list all queries executed by a particular user gainst a single instance

I have been asked to show all queries a particular user has executed over the past 3 months. In particular against one instance of MS SQL and a single database on that instance.

Can this be achieved through DPA? If so how do I do it? I am an extreme novice when it comes to DPA so any help or guidance would be much appreciated.

0 Kudos
1 Reply
Level 17

@juddl 

Here is a custom report that might help: https://thwack.solarwinds.com/t5/DPA-Documents/Custom-Report-Top-SQL-for-Database/ta-p/529535

The report is fairly old, I'm not sure if it will still work as expected. If it does not work, drop an email to support and ask for help in creating the exact report you need. 

HTH

0 Kudos