Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Searching custom SNMP properties for NULL Value

jbandy1

Any way to create a dynamic query to look for a empty or $Null field?

Find more posts tagged with

Accepted answers

All comments

bluefunelemental

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,'') = ''

jbandy1

Empty SYS_Type Catagory

bluefunelemental

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.

Screen Shot 2015-02-27 at 7.52.03 PM.png

bluefunelemental

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....