See the last X weeks of User transactions/SQl statments ran on the server
Have a view in SQlMonitor that can be used to do a quick search on what querys a user has run on SQL Server over the last X weeks.
For our user case we would just need the data for the last two weeks but sure if storage allows user's would like to hold the data for longer.
This is to enable some auditing functionalty to quickly find what a user has ran for reporting.
e.g.
What did user1 run yesterday,
What was run and by who over the last hour
This could also help with finding performance issues. For example user1 is reporting problems with their querys but it dosn't appear in the top 10-50 sql statments in the current view.
Exporting into csv would also be useful.