Scripted Poller Change?

I couldn't find a definitive answer to this question: I just added a new poller and need to move three thousand nodes to the new poller.

After I shut down the pollers, can I use a SQL script to change the 'engineid' field in the NODES table to the appropriate value (ie from 2 to 3) instead of using the GUI?

If not, are there other tables that need to be updated or is there a stored proc that can be executed with a parameter passed in like 'nodeid'?

Thanks

Scott Fairbanks

Find more posts tagged with

Accepted answers

All comments

borgan

Scott,

Use the Monitor Polling Engines tool in the SolarWinds Orion Advanced Features program menu to move the nodes to the new poller. Select the nodes that you want to move then select the Move selected Nodes to option under the Polling Engines menu in the tool. That will re-assign the nodes to the new polling engine.

ScottForJC

Thanks for the reply. I've used this tool before, but it takes quite a while to move 3,000 nodes so I'm looking for a quicker way. If the only field that has to be updated is the engineid field in the nodes table, my DBA can script it ahead of time and run it in a few seconds after I shut down the pollers. My downtime is only 5 minutes instead of 30 minutes or an hour.

neilmborilla

I have moved tons of nodes with no issue (no data collection has been lost). I used "Monitoring Polling Engine"

julrich

I've had to do this before, it's very easy

Just run this SQL query against your Orion databse:

UPDATE NODES set EngineID = ‘3’ WHERE EngineID = ‘2’

Just make sure all of your pollers are shut down before doing this

ScottForJC

Thanks Jonathan. That's what I was hoping.