I have a load F5 Load balancing SQL query that works for SQL, but this new KPI Widget which requires SWQL. But my SQL doesn't work of course and need help to translate a SQL into a SWQL query. I have several hundred LoadBalanced VIP's that I need to do this for and really could use some help or a push in the right direction.. Here is the SQL Query
SELECT VSS.DateTime, (vs.Name + ' ON ' + n.Caption) AS [Name], VSS.Connections
FROM F5_LTM_VirtualServer_Stats VSS
LEFT JOIN F5_LTM_VirtualServer vs ON VSS.VirtualServerID = vs.VirtualServerID
LEFT JOIN Nodes n ON vs.NodeID = n.NodeID
WHERE (VSS.DateTime >= DATEADD(hour, -24, GETDATE())) AND (VSS.VirtualServerID = 1618)
ORDER BY VSS.Connections DESC
Thank You
D.Walker
UW Medicine
