This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

EOC, SWQL AgentManagement tables not accessible to EOC

 I left any custom properties out for the example:  How can I get this information in an EOC report. in 2020.2  This SWQL query works at the Orion Server level.

SELECT
N.NodeId
,AMA.Name
,AMA.AgentVersion
,AMA.AutoUpdateEnabled
,AMA.RuntimeOSDistro
,RuntimeOSVersion, RuntimeOSLabel, OSLabel
FROM Orion.AgentManagement.Agent AMA
Inner JOIN Orion.Nodes N
ON AMA.NodeId = N.NodeID
AND AMA.OrionSite.SiteID = N.OrionSite.SiteID

I understand that when I scroll through Orion.AgentManagement.Agent  using SWQL studio the information is empty at the EOC level because the EOC does not have Agents.