Balance nodes based on custom property

Question

Hello,

I'm in the process of re-architecting NPM's role in our environment.  Part of this requires that all our routers be on a single poller so we can up the retention period for statistics, etc.  I have moved all the nodes off the poller that will do the data collection, but I need to know if there is a good way to move all devices that fit a certain criteria onto a single poller.  I see the EngineID column in the nodes table, and I can easily run an UPDATE that changes all the desired devices to be on another poller, but I'd just like verification that I won't break anything else if I do that.  If the SQL update is not an option, is there a good way to do this without having to pick through the entire list?

GregD · Accepted Answer

I had seen that, and had gone into the "poller load balancing" option in that program, but the only columns that were available to me were Engine, Caption, and IP_Address.  I couldn't find a way to add my custom property.

What I ended up doing was this:

1.) Shut down all the polling engines.

2.) In Query Analyzer, run this statement:

update nodes

set caption = 'AA_' + caption

where model = 'Router'  <-- My custom property

3.) Go into the load balancer program, sort by caption, and assign to the correct poller

4.) Run the following SQL command:

update nodes

set caption = right(caption, len(caption)-3))

where model = 'Router'

Not the most elegant solution, but it worked :)