Report on Nodes that DON'T have any Custom Poller Assigned

Deltona

Hi guys,

I am trying my best to avoid using SWQL or SQL when creating this report but I'm not sure its possible.

What I am trying to achieve is having a list of specific nodes (custom property based) show up if they don't have ANY UnDP/Custom Poller assigned.

So far I've tried doing this by specifying either Custom Node Poller Assignment ID is empty, Status is not Up, Value/Rate etc is empty.

Nothing seems to work. Has anyone tried this and are you willing to share how it can be done?

TIA

shuth

You can use something like below:

SELECT n.Caption, n.IP_Address, n.CustomProperties.City
FROM Orion.Nodes n
WHERE n.NodeID NOT IN 
( SELECT NodeID FROM Orion.NPM.CustomPollerAssignment )
AND n.CustomProperties.Department = 'blah'

Replace the custom property fields as appropriate.

If you remove the last line with the "AND n.CustomProperties.xxxxx " clause, the query should return every Node that doesn't have ANY UnDP assigned (the NodeID doesn't exist in the CustomPollerAssignment table). You can add additional clauses if you want to filter based on specific UnDPs.

SELECT n.Caption, n.IP_Address, n.CustomProperties.City
FROM Orion.Nodes n
WHERE n.NodeID NOT IN 
( SELECT NodeID FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerName = 'examplepoller' )
AND n.CustomProperties.Department = 'blah'

There may be a more efficient way to structure the query but that should work.