Adding SNMP to multiple existing nodes in 8.5?

Question

Hiya.

I've had to add a bunch of existing nodes to an orion 8.5 server, and at the time we didn't have the SNMP community string available so they were added as ICMP only devices.

I now do have the SNMP string so I want to go back and enable SNMP support but can't see a quick way of doing this.

It's obviously possible to re-add the devices one at a time and supply the SNMP string there , but that's long winded and tedious.

If I re-run the discovery (based on a seed file) it sees all the devices and their interfaces , but when I import them it doesn't change them from ICMP-only devices as doing them one at a time does.

I could delete all the existing nodes and then redo the discovery which would work but lose the historical data we have collected.

Am I being a bit dumb here , or isn't there another easier option?

FormerMember · Answer

See, while upgrading is painful, it does come with some rewards.

Network_Guru · Answer

Wow, that's cool, thanks for that nugget of info Denny! I just tried this in V9.1 and it works great. Open the Orion DB Manager and open the Nodes table. Run a query like this: Select Top 1000 * From Nodes Where ObjectSubType = 'ICMP' This will show you the first 1000 Nodes which are set to poll with ICMP only. Find or assign a common custom property to all the nodes you want to change to SNMP. Then run a query like this (make sure you have changed the Radio button to Read-Write: AS YOU ARE EDITING THE DB DIRECTLY, PLEASE ENSURE YOU HAVE BACKED IT UP BEFORE MAKING ANY CHANGES LIKE THIS Update Nodes Set ObjectSubType SNMP Where = 'VALUE' You can also assign the Community string using this method: Update Nodes Set Community Where = 'VALUE' Now you will still have go and discover the resources for each server individually, but at least you have maintained your historical ICMP polling data. HTH.

FormerMember · Answer

When changing the DB manually you must stop your polling engine(s), so I wouldn't consider this easier.

While this statement is true of older versions of NPM, it is no longer true.  As of v9, you can make changes to the database without stopping the polling engine.   The polling engine will now recognize the database as authoratative and pick up your changes.