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

sum_giais

Top Comments

sum_giais 1 month ago in reply to CourtesyIT +1

Hello CourtesyIT, there's a WHERE statement that needs adjustments or to be removed if doing a cut/paste. I probably should have noted that in there.

Remove the line 'WHERE a.Node.NodeID = 1' and it…

CourtesyIT 1 month ago in reply to sum_giais

Thanks for you help.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
sum_giais 1 month ago in reply to CourtesyIT

Hello CourtesyIT, there's a WHERE statement that needs adjustments or to be removed if doing a cut/paste. I probably should have noted that in there.

Remove the line 'WHERE a.Node.NodeID = 1' and it should work.

Let me know!
- Cancel
- Up +1 Down
- Reply
- More
- Cancel
CourtesyIT 1 month ago
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
CourtesyIT 1 month ago

This is what I get when I paste the code into a custom table.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel