Query for agent info source via the agent tables

SELECT
	 n.Caption AS [NodeCaption]
	,n.ObjectSubType AS [NodePollingMethod]
	,n.IP_Address AS [NodeIP]
	,a.IP AS [AgentIP]
	,n.NodeID AS [RealNodeID]
	,a.NodeId AS [AgentNodeID]
	,n.SysName AS [NodeHostName]
	,a.Hostname AS [AgentHostName]
	,a.AgentGuid
	,a.AgentId
FROM Orion.AgentManagement.Agent AS a
LEFT JOIN Orion.Nodes AS n ON n.NodeID = a.NodeId

Anonymous