2 Replies Latest reply on Aug 24, 2016 11:21 AM by KMSigma

    SWQL value for Node Netflow Exporter (NTA)

    josh.haberman

      I'm trying to generate a report using a SWQL query that shows a list of nodes that are sending Netflow data to NTA.  I'm not able to find a value that will show this.  The closest I found is "Orion.Netflow.Source.Enabled" but, that only tells through True/False whether the node is capable of sending Netflow.

       

      Any help would be much appreciated!

        • Re: SWQL value for Node Netflow Exporter (NTA)
          aplonka

          Just use "LastTime" column for this purpose. This column tells you when the last Flow from given device was processed.

          For example if want to get NetFlow exporters from the last 24 hours you can use the following query:

           

          SELECT DISTINCT NodeID, Source.Node.IPAddress, Source.Node.Caption
              FROM Orion.Netflow.Source
              WHERE HOURDIFF(LastTime, GETDATE()) < 24
          
          • Re: SWQL value for Node Netflow Exporter (NTA)
            KMSigma

            Here's what I came up with:

            SELECT 
                    N.Caption AS [Node Caption],
                    I.Caption AS [Interface Caption],
                    NFS.LastTime ,
                    NFS.cbQoSEnabled ,
                    NFS.cbQoSLastTime ,
                    NFS.LastTimeAAR ,
                    NFS.LastTimeWLC ,
                    I.InterfaceName ,
                    I.InBandwidth ,
                    I.OutBandwidth ,
                    I.OutPercentUtil ,
                    I.InPercentUtil
                    
            FROM    Orion.Nodes AS N
                    INNER JOIN Orion.Netflow.Source AS NFS ON N.NodeID = NFS.NodeID
                    INNER JOIN Orion.NPM.Interfaces AS I ON NFS.InterfaceID = I.InterfaceID
                                             AND NFS.NodeID = I.NodeID
            WHERE   ( NFS.Enabled = 1 )