SWQL Quary request

e.jenidy

 I have this SQL Quary and need to write it on SWQL.

Can anyone help me? 

SQL code: "SELECT CustomPollerStatus.Status, CustomPollerAssignment.NodeID, Nodes.Caption,
CustomPollerAssignment.AssignmentName
FROM CustomPollerAssignment LEFT OUTER JOIN
Nodes ON CustomPollerAssignment.NodeID =
Nodes.NodeID RIGHT OUTER JOIN
CustomPollerStatus ON CustomPollerAssignment.CustomPollerAssignmentID =
CustomPollerStatus.CustomPollerAssignmentID"

marcrobinson

Try this to get you started. The orion.npm.custompoller**** entities should have the custom poller statistics that you want. 

SELECT TOP 100 cpon.AssignmentName, cpon.NodeID, n.Caption, cpon.RawStatus, cpon.Status FROM Orion.NPM.CustomPollerStatusOnNode cpon JOIN orion.nodes n on n.NodeID = cpon.NodeID