Need to do a mass update of community strings

Question

I need to change the community string on a long list of nodes so that IPSLA operations can be configured on them. Unfortunately, the discovery process discovered those nodes with a RO string first, so that's the way they appear in the Orion database.

What is the easiest way to change all of those nodes to a RW string? Can I run discovery again? Should I make mass changes in DB Manager, or should I do this in Node Management? If I do it in node management, is there a way to display only the nodes that have a certain string so I can select all of them at one time?

I should have performed a network discovery with only the RW string first, so that all those nodes would be in the database using that string, agreed?

Thanks for the help.

njoylif · Accepted Answer

If you are SQL savvy you can do the following as well....as always, back up your DB prior to having any fun...
to test prior to...use select instead of update/set
select * from Nodes where RWCommunity = ''

BELOW will set the RW community for ***ALL*** Nodes
xxxxxx = your RW community string

update Nodes
set RWCommunity = 'xxxxxxx'

if you want to only do ones that don't have RW string set add:::

where RWCommunity = ''