Agent not collecting data - Can we create alert for it..?

Dear Thwack members,

Have anyone encountered a scenario like, Agent is absolutely UP & running, but it's not collecting any data at all from the backend & SolarWinds still shows the old data collected days ago. 

In this case, can we create any alerts for "last polling data not received"..?

Thanks in advance..!

-Solaiy.

Parents Reply
  • HI , This example Custom SWQL alert will trigger if the LastSystemUptimePollUTC is not updated in the last 120 minutes.

    SELECT Nodes.Uri, Nodes.DisplayName FROM Orion.Nodes AS Nodes
    
    LEFT JOIN Orion.NodeSettings ns ON Nodes.NodeID = ns.NodeID AND SettingName like '%Credential%'      
    LEFT JOIN Orion.Credential c ON ns.SettingValue = c.ID      
    JOIN Orion.Engines e ON e.Engineid=Nodes.Engineid  
    --WHERE Status<>'2'  
    -- Status Not Down, UnManaged, Unreachable  
    WHERE Status NOT IN ('2', '9', '12')  
    AND ObjectSubType='AGENT'  
    AND MinuteDiff(LastSystemUptimePollUTC,GETUTCDATE())>120 
    
    ORDER BY LastSystemUptimePollUTC

Children