Comments
-
I already tried but no luck. Output is having both nodes with Solarwinds agent running and not running/ SELECT n.Caption,n.Agent.AgentStatusMessage AS Agent_AgentStatusMessage,n.Agent.AgentStatus AS Agent_AgentStatus FROM Orion.Nodes n WHERE n.Agent.ConnectionStatusMessage like '%Unable to connect to the agent%' and…