I found an old post that didn't really go anywhere on the subject, so I thought that I'd give the problem another try.
I have a large number of nodes that I'd like to change the SNMP RO and RW community strings for. I can script the change on the nodes themselves using Cirrus Configuration Manager, and would now like to do a bulk change in Orion (v 8.5.1) for the monitoring purposes.
The previous thread suggests the following:
------------------------------
you can do this via the read/write aspect of solarwinds database manager
update nodes
set community = 'NewCommunity'
where community ='OldCommunity'
------------------------------
Since I only want to run this against my Nortel equipment (most report as Synoptics), I suppose that the full query will look like this:
update nodes
set community = ''new-RO-community'
set communityRW = 'new-RW-community'
where community ='old-RO-community' and communityRW='old-RW-community' and Vendor='Synoptics'
The entire update process will then go as such?
-Open SolarWinds Database Manager
-Expand NetPerfMon database > Right-click Nodes table and select Query
-Test the lookup portion by ensuring that the Read-Only button is selected, and input the following query
Select *
From Nodes
where community ='old-RO-community' and communityRW='old-RW-community' and Vendor='Synoptics'
-Click Refresh to view the results of the query and ensure that the proper records are being viewed
To make the change:
-Change the Query method to Read-Write
update nodes
set community = ''new-RO-community'
set communityRW = 'new-RW-community'
where community ='old-RO-community' and communityRW='old-RW-community' and Vendor='Synoptics'
Any input would certainly be helpful. I think that I've got it sorted out, but I'd still like some feedback.
Thanks.
