Looking for some guidance regarding SQL and SWQL
I can create a SQL report and plot it on a graph however when I go to create that same report in SWQL I can't select the Data Series for Y AXIS. The preview returns the same data.
SQL
_------------_
SELECT
STATS.DateTime DateTime,
VIP.ShortName AS VIP,
STATS.connections AS Connections
FROM [dbo].[NodesData] N, [dbo].[F5_LTM_VirtualServer] VIP, [dbo].[F5_LTM_VirtualServer_Stats] STATS
WHERE N.NodeID=VIP.NodeID
and VIP.VirtualServerID=STATS.VirtualServerID
and N.Caption='F5 Devie'
and VIP.ShortName='VIP NAME'
and STATS.DateTime >= ${FromTimeUTC}
ORDER BY DateTime
_------------_
SWQL
_------------_
Select
STATS.DateTime AS DateTime,
VIP.ShortName AS VIP,
STATS.connections AS Connections
FROM Orion.Nodes N, Orion.F5.LTM.VirtualServer VIP, Orion.F5.LTM.VirtualServerStats STATS
WHERE N.NodeID=VIP.NodeID
and VIP.VirtualServerID=STATS.VirtualServerID
and N.NodeID=VIP.NodeID
and N.NodeName='F5 Devie'
and VIP.ShortName='VIP NAME'
and STATS.DateTime >= ${FromTimeUTC}
ORDER BY STATS.DateTime
_------------_
