Anyone know how to use SQL to add new nodes directly to the database? I have a large number of devices I need to monitor with ICMP only. I don't want to scan subnets because there are too many of them and the seedfile.txt method only works for SNMP ebabled devices which these are not.
It is not possible to add nodes directly to the DB, as there are many other tables which must be updated when even an ICMP only node is added.
Many on these forums have tried, but to my knowledge, no one has been successful.
Is there any update to this? I need to add about 500 ICMP only devices, tech support said it was possible to add them directly to the nodes table but he was very vague and didn't have any specifics other than turning off the services....any gotchas before I try this?
Let me add a little, we have our SQL gurus ready and if we can add only to the ICMP only nodes table with the appropriate fields then turn the service back on we will be good. It's if there are other hooks that are needed, we obviously won't be successful. I have to believe someone has spent time attempting this.......anybody have any insight?
Thank you for the reply and link, much appreciated that you take the time. I understand that you are probably tired of this question, however, adding so many ICMP nodes through the gui will take a substantial amount of time. If there was any way to get direction or clarification regarding an import method for icmp only nodes, even though unsupported, it would be huge. I know your dev team is afraid of people causing more problems for themselves so don't necessarily want to encourage something like this but it would help us out immensely if you were to help us find a way, we have easy fallbacks, snapshots, etc. and are willing to give it a shot if we just knew where the dependancies on adding these nodes lie....
Is there any reason you can't use the Host Seed File method? It runs the discovery engine, but it's limited to just those nodes that you list in a formatted text file. Would that not work?
We just captured the INSERTs via SQL Profiler and examined which fields were required and then wrote our own SOAP service to add nodes. With it being highly experimental and not supported (though we've never had issues) I don't want to give advice to do this, but there isn't actually a lot to insert into the DB if you're just doing ICMP.
Couple of reasons, we are attempting to add these as ICMP only monitoring to conserve the resources of the server, it is my understanding that the seed file method is only supported with snmp monitoring of those nodes. Also when we tested this in smaller numbers there was manual manipulation of every node after adding it in the seed file way. We gave that a good effort but just couldn't make it work on scale.
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.