Custom property values will be null if nothing has ever been entered for that property on a given node. If something was entered and later deleted, they will be empty ('').
To catch both cases, you can use the SQL isnull function. If your property called is Notes, then this query should do it:
SELECT * FROM Nodes WHERE ISNULL(Notes, '') = ''
I would like to do the same thing but instead delete all rows that have a null value for a certain Custom Poller from the Universal device poller program, could you provide me with that SQL code?
Custom pollers are more complex. Could you give me a more detailed description of what you are trying to do? Are you trying to remove nodes? Or just custom poller assignments?
We have a custom poller (OID: 1.3.6.1.2.1.47.1.1.1.1.11) that Polls every node in our network for serial numbers. However, every piece of hardware may not have a serial number. For example, in the following output, I only want to display the information for the 2x 10Gbase-ER GBIC's. I want to delete all rows in the table where the OID above is blank. In addition, I would like to put together a report that showed me all Serial Numbers for all nodes in the network.
So, can you help me write a report that shows me all serial numbers in the network with their interfaces and media type for all nodes in our network? Also, my custom poller is no longer polling for serial numbers and I would like to just delete all rows in the "CustomPollerStatistics_Detail" where the column "Status" is empty. Can you help out with my requests?
