0 Replies Latest reply on Jun 25, 2016 12:57 AM by andrew.grech@tattsgroup.com

    Unable to graph SWQL but can graph SQL NPM12

    andrew.grech@tattsgroup.com

      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.

       

      Cheers

       

            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

      _------------_