Get all querys run on a server by date range and who ran it

Nick9053

Hi All,

Just wondering if anyone has done a query in the back end to get data on query's run and by who.

As SQLMonitor seems to have this data but only seem to be able to get it by date range and grouped up or when blocking from the front end UI?

Hoping to avoid having to have another job/process do this auditing.

Russell D

I'm afraid there isn't - it's something we're looking at improving/providing but at this stage its in its infancy I'm afraid. If you post exactly what you're after over on the sql monitor uservoice https://sqlmonitor.uservoice.com/forums/91743-suggestions we use that to help prioritise work.