Good day,
Per the topic, I am trying to link the SQL text that has been run on the monitored server, with the login/host that ran it, from within SSMS.
Is there a way to do it? If so, how?
For those wondering, the reason I need this in SSMS, is because this is to be part of a statistical analysis which I am pulling using SSMS directly, rather than the application.
I want to see how many times per hour (of the day), on average over a week, was an SQL statement ran.
Then, we have SQL statements where the only thing reported is, that the SQL text was not reported by the database (there is an open question about this issue), for these I need the logins/hostnames that executed them, so I can at least see where they come from.
Monitored Server: Sybase ASE 15.7
SolarWinds DPA: 11.0.378
MSSQL Server: SQL Server 2014 (12.0.2000.8)
Message was edited by: Shay Terreni Accidentally clicked on "assume answered"....... This is not answered.