Changing SNMP string used by Orion

I have been tasked with changing the ommunity string on several (more than 100) devices currently being monitored at a customer site.

Is there a way to update these nodes in bulk? rather than having to change them one at a time?

Thanks,
P. B.

Success requires three bones--wishbone, backbone and funnybone. Kobi Yamada

Find more posts tagged with

Accepted answers

All comments

Network_Guru

You can change these in the DB directly with this query.
You can see the data & fields in the DB using the Orion DB Manager.
Edit the Community String in the database directly by running a query similar to;

Update nodes
Set Community=<new-name>
Where Community=<old-name>

using the Database Manager.
Make sure you have select the - Read/Write option in the DB Manager before running this query.

-=Cheers=-
NG

jdub

I modified my Database via the database manager, and it just updates and switches back to the old communities. Am I doing something wrong?

Josh_Stephens

PB,
Before running the query, be sure to stop all of your polling engines (shutdown the Network Performance Monitor services).

The polling engine runs from an in-memory model and will periodically sync to the database. When this occurs, it will overwirte any changes that you made to the database. If you stop the services first, they will learn your changes upon startup and it should all work without issue.

Thanks,

Josh Stephens
SolarWinds R&D