Display Node and Agent ID on View

shocko

Guys, I would like to display the following info on each nodes default view:#

• NodeID
• AgentID (if windows/linux and polling with an agent)

What might be an approach I could here? 

shuth

The NodeID is shown in the URL:

servername/.../NodeDetails.aspx431

You could also add a Custom Query resource to the Node Details view and use a query like below. I'm not sure of all the fields you're after but you can edit the query as required.

SELECT
  n.NodeID AS [Node ID]
, n.Agent.AgentId AS [ID]
, n.Agent.AgentGuid AS [GUID]
, n.Agent.ConnectionStatus AS [Connection]
, n.Agent.AgentStatusMessage AS [Status]
, n.Agent.AgentVersion AS [Version]
FROM Orion.Nodes n
WHERE n.NodeID = ${NodeID}

 

I pulled from Orion.Nodes as the same query will still return the NodeID for nodes that don't have agents.

These are the fields available in the Agents table:
AgentId, AgentGuid, NodeId, Name, Hostname, DNSName, IP, OSVersion, PollingEngineId, ConnectionStatus, ConnectionStatusMessage, ConnectionStatusTimestamp, AgentStatus, AgentStatusMessage, AgentStatusTimestamp, IsActiveAgent, Mode, AgentVersion, AutoUpdateEnabled, OrionIdColumn, PassiveAgentHostname, PassiveAgentPort, ProxyId, RegisteredOn, SID, Is64Windows, CPUArch, OSArch, OSType, OSDistro, ResponseTime, Type, RuntimeOSDistro, RuntimeOSVersion, RuntimeOSLabel, OSLabel