1 of 1 people found this helpful
You can use SWIS to update the EngineID value on the Orion.Nodes entity to reassign nodes from one polling engine to another. (Set-SwisObject in powershell)
Are you sure that altering the Nodes table is sufficient for assigning nodes to different polling engines?
Looks like it could break some references with other tables in Orion DB....?
Below a list of all Columns called EngineID occuring in Orion DB:
SELECT * FROM information_schema.columns WHERE COLUMN_NAME = 'EngineID'
Thanks for your comments....
fyi, I got confirmed that it is sufficient to change the EngineID in the Nodes table
Currently we do this directly via scheduled SQL job, maybe we'll trigger this by script in future through the API....
change the bottom 50% of the Nodes table:
UPDATE X SET EngineID =
(SELECT EngineID FROM Engines WHERE ServerName = '[POLLER SERVER X]')
(SELECT TOP 50 PERCENT * FROM Nodes ORDER BY NodeID DESC)
change the top 50% of the Nodes table:
UPDATE Y SET EngineID =
(SELECT EngineID FROM Engines WHERE ServerName = '[POLLER SERVER Y]')
(SELECT TOP 50 PERCENT * FROM Nodes ORDER BY NodeID ASC)