This dashboard includes a single widget that shows you the status of the SolarWinds' Agent installed within your environment.
Hi, I'm new here, I design this one for my dashboard, but you can modify it as you need or wish
For example, you can use TOP n clause,
or the ORDER BY n clause, or remove Properties from SELECT
or you can add a WHERE clauses or remove it, for example WHERE (ConnectionStatus) = 2 --#2 is Down Status
SELECT AgentId, Nodes.NodeName, Nodes.DetailsUrl AS [_LinkFor_NodeName], Agent.Uri AS [_LinkFor_AgentID], Agent.NodeId, DNSName, Agent.IP, ConnectionStatus, ConnectionStatusMessage, ConnectionStatusTimestamp, AgentStatus, AgentStatusMessage, AgentStatusTimestamp, IsActiveAgent, Mode, AgentVersion, AutoUpdateEnabled, Agent.OrionIdColumn, PassiveAgentHostname, PassiveAgentPort, RegisteredOn, Agent.ResponseTime, OSType, OSVersion, OSLabel, NetFrameworkRelease
FROM Orion.AgentManagement.Agent AS Agent
INNER join Orion.Nodes AS Nodes
on Agent.NodeID = Nodes.NodeID
ORDER BY (RegisteredOn) DESC
Let me know if it helps.
Is there a SWQL version for this?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 190,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.