We are in the midst of migrating from various other platforms to NPM.
I've done an import of nodes and everything is working.
On the one instance that monitors our customer CPE devices, I'm looking to do some clean up of the import. Is their a way with an SWQL or SQL query to get a list of nodes that have NEVER been up and NEVER been contacted?
Yep, that's true, for ICMP nodes this will be blank. Hmmm.... As far as I can see there is no indication in Nodes table for ICMP nodes to say if they have ever been ping-able. You may need to create your trigger with Events instead.
I would probably take SQL approach by selecting down/unknown nodes from NODES table and then searching EVENTS table and excluding any nodes which had an event "node is up" in the past. Let me know if you need help with SQL
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.