• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 23 subscribers
  • Views 545 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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!

  • 0

    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
  • 0

    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 )

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.