I run a Network Sonar Discovery weekly to import new interface connections every week. We have a large network, so each poller we process discovery on takes several minutes to process.
When we are running the discovery, any database connection timeouts or other errors runs the risk of causing SolarWinds to import all of the interfaces on a node, whether they are in use or shut down.
In two of the last three discovery runs, instead of 4 nodes with 3 or 4 new interfaces, I get 120 nodes with 2000 interfaces. Out of the 2000 new interfaces, 12 are legit, and the rest now need to be removed. How can I automate this?
Obviously don't run discovery if the system is dropping database connections, but in case it happens anyway I need a recovery plan that doesn't involve opening 120 nodes, running list resources, waiting a couple minutes, then deselecting the unused interfaces... at 4 or 5 minutes per node it might take 8 man hours to recover without a swql mass edit. swql should be able to do it in a minute or so.
