Since SolarWinds support is so lame that they won't help you out on information that I found on their website i'll ask here because i've not found any information here.
You see, solarwinds has all of the "cool" dashboards that can be created but yet they don't help you and there is minimal help here from the so called "geeks"
We hare a hospital and we are monitoring COVID19 stats via a web site on an F5 virtual server. I want to be able to display a single number based on current users logged into the website with the correct virtual server id. Now the swsq i have works, gives me the date but yet this so called "cool" widget displays nothing. maybe some has created a KPI Widget that displays current connections for a give virtual server based on the virtual server id;
THIS does give me the data i want, even shows in the "widget builder" that the code does validate. ..
SELECT VSS.DateTime, VSS.VirtualServer.Name, VSS.Connections
FROM Orion.F5.LTM.VirtualServerStats VSS
WHERE (VSS.DateTime >= ADDDATE('MINUTE', -12, GETUTCDATE())) AND (VSS.VirtualServerID = 2565)
ORDER BY VSS.DateTime, VSS.VirtualServer.Name ASC
