This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

How do I make multiple SNMP changed to nodes?

I recently upgrade to 8.1 and so far I love it. There is one problem though, we monitor over 560 Pix 501s who only support SNMP version 1 and Orion defaults them to SNMP version 2. So my question; is there a way to change these devices to SNMP version 1 with one click, or couple key strokes.


 


Bret

  • Yes. You can use the following script, run against the Nodes table in the Orion database (NetPerfMon by default), to change all your up but unknown interfaces from SNMP v2 devices to SNMP v1. Before running queries against your database, ensure you first backup the database.

    1. Stop the SolarWinds Network Performance Monitor service using the Shutdown NetPerfMon utility provided with Orion NPM. By default, you can find this program at Start > All Programs > SolarWinds Orion Network Performance Monitor >Advanced Features >Shutdown NetPerfMon.
      Warning:
      • Stopping the SolarWinds Network Performance Monitor service also stops node polling. Consider doing any maintenance that requires the stopping of the service during a slow business cycle.
      • Before Stopping the SolarWinds Network Performance Monitor service, ensure you stop the SolarWinds Alerting Engine. Failure to stop the SolarWinds Alerting Engine will result in numerous alert notifications.
    2. Click Start > All Programs > SolarWinds Orion Network Performance Monitor > Database Utilities > Database Manager on your Orion NPM server.
    3. Locate and expand your Orion NPM database in the navigation pane.
    4. Click the Nodes table, and then click Table > Table Details.
    5. Click Query on the Table Details window.
    6. Type the following in the Query window:
      update nodes
      set snmpversion = 1
      where snmpversion = 2
      and GroupStatus = 'Up-Unknown.gif'
      Note: This SQL statement changes those nodes that are currently up, have unknown interfaces, and are currently using SNMP version 2 to use SNMP version 1.
    7. Click Refresh.
    8. Exit the Database Manager.
    9. Restart the SolarWinds Network Performance Monitor service using the Shutdown NetPerfMon utility provided with Orion NPM.
  • Thanks Mark, this was right on the money. I was heading in this direction, doing them individually and failed to stop the NPM so the changes never took affect; your way was awesome. One thing to consider for those out there who use this fix, it will take a few minutes for it to update all the devices, so be patient. In my case there were 560 pixs and it took about 15 min.