So Solarwinds has this widget under Load Balancing called "Concurrent Connections by Virtual Server" which is great if you have any F5's in use. The only problem is, you can't filter for any virtual servers in the widget!! All you get for widget editing is to increase the number of virtual servers to display to a max of 10. Which means, your virtual servers need to be in the top 10. And as far as reporting goes, there isn't even a report for this. I was able to create a SWQL report to show last 24 hours of connection stats for the virtual servers in question. But and I only get table data.. If I try to put the result set into a chart, it's doesn't seem to work.
My SWQL statement is:
"SELECT VSS.DateTime, VSS.VirtualServer.Name, VSS.Connections
FROM Orion.F5.LTM.VirtualServerStats VSS
WHERE (VSS.DateTime >= ADDDATE('HOUR', -24, GETUTCDATE())) AND (VSS.VirtualServerID = 552 OR VSS.VirtualServerID = 864 OR VSS.VirtualServerID =1694)
ORDER BY VSS.DateTime, VSS.VirtualServer.Name ASC"
Any help on putting this in a chart would be much appreaciated.
