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 query to list Netflow received on unmonitored nodes

With the help of smttysmth02gt​ I was able to put together a SWQL query you can put into a "Custom query" widget or report in order to see all IP's that were sending netflow that you aren't polling from in Orion. This trims out everything from the event which otherwise would say:

NetFlow Receiver Service [ORIONSERVER] is receiving a NetFlow data stream from an unmanaged device (10.58.35.1). The NetFlow data stream from (IP) will be discarded. Please use Orion Node management to manage this IP address in order to process this NetFlow data stream, or just use <a href="">thwack.solarwinds.com/.../AddNode.aspx this device</u></b></a>.

SELECT EventTime
, EventType
, SUBSTRING(Message, CHARINDEX('IPAddress=', Message) + LENGTH('IPAddress='), CHARINDEX('"', Message, CHARINDEX('IPAddress=', Message)) - (CHARINDEX('IPAddress=', Message) + LENGTH('IPAddress='))) AS IPAddress
-- this will grab between ( and ) to get the IP from the Netflow Event
FROM Orion.Events
WHERE EventType = 302 --unmanaged Netflow Node Event
ORDER BY EventTime DESC

The result of this looks like so, when run from SWQL studio or elsewhere. If you have lots of netflow events, this can be helpful in case it slides well past your netflow events history.

pastedImage_1.png