Hi,
refer- - Configure Flow alerts (solarwinds.com) --> Configure the alert NetFlow source not receiving any data, this is exactly what I am trying to figure out but I need to include only the named devices (some set of selected devices), in this example, 25915 is the InterfaceID in the Orion database, I managed to get the list InterfaceIDs , how to add this to below script?
I tried with including multiple InterfaceIDs (25915 ,251100, 25400, etc) but it does not work, seek some support.
------------------------------------------------------------------
Interface
SELECT Interfaces.Uri, Interfaces.DisplayName FROM Orion.NPM.Interfaces AS Interfaces
INNER JOIN (
SELECT DISTINCT InterfaceID FROM Orion.Netflow.Source
WHERE LastTimeFlow < AddMinute(-5, GETUTCDATE())
AND Enabled=True
AND (
EngineID IS NULL OR
EngineID NOT IN
(
SELECT EngineID FROM Orion.Netflow.FlowEngines
WHERE FlowCollectorKeepAlive < AddSecond(-90, GETUTCDATE()) OR
AddMinute(6, FlowCollectorStartTime) > GETUTCDATE()
)
)
AND InterfaceID IN (25915)
) as Source
ON Source.InterfaceID = Interfaces.InterfaceID
WHERE Interfaces.InterfaceID NOT IN (
SELECT EntityID FROM Orion.NetObjectDownTime
WHERE EntityType = 'Orion.NPM.Interfaces'
AND DateTimeUntilNow > AddMinute(-5, GETUTCDATE())
AND State = 9
AND EntityID IN (25915)
)
------------------------------------------------------------------------------------------
