Orion agent plugin details

SELECT
    a.Plugins.PluginId
    ,a.Plugins.Status
    ,a.Plugins.StatusMessage
    ,a.Plugins.Version
    ,a.Name
    ,a.IP
    ,a.AgentId
    ,a.AgentGuid
    ,a.Node.NodeID
    ,a.AgentStatus
    ,a.AgentStatusMessage
    ,a.ConnectionStatus
    ,a.ConnectionStatusMessage
FROM Orion.AgentManagement.Agent AS a
WHERE a.Node.NodeID = 1