Any way to create a dynamic query to look for a empty or $Null field?
Which snmp properties are you searching?
SELECT Nodes.Caption AS [Node]
, '/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(nodes.nodeid) AS [_LinkFor_Node]
, '/Orion/images/StatusIcons/Small-' + nodes.StatusLED AS [_IconFor_Node]
,Contact
,Location
FROM Orion.Nodes
WHERE IsNull(Nodes.Contact,'') = '' OR IsNull(Nodes.Location,'') = ''
In case I missed your meaning Group Dynamic queries - that interface is weak but I believe just specifying is and leaving the value empty will work. Do one for Contact and another query for Location - if you add both to one query it's additive and will only match those with both empty.
custom OID's are not in the drop down menu - you might need to explore setting a node custom property based on a custom poller empty or NULL value - then use the custom property to drive group dynamic query logic... not really to tough but script or SQL agent job....
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.