Assign or manually update vendor to an ICMP node in SolarWinds Platform

10/12/2018 12:06 PM

6/8/2026 3:57 PM

ICMP nodes added in SolarWinds Platform has unknown Vendor showing up in the webconsole. You can manually modify the vendor assigned to ICMP nodes thru the database.

Network Performance Monitor

The Vendor, MachineType, and other data are typically acquired through SNMP or WMI. The data is not available when polling via ICMP so it must be set manually.

Notes:

• This will not work with nodes added via SNMP.
• For nodes added via SNMP, please see the following article:
  • Machine Type or Vendor is not detected via SNMP in Orion Platform

1. Go to Start > All Programs > Solarwinds Platform > Database Manager > Add Orion Server.
2. Right click on the NPM Database (default) SolarWindsOrion 
3. Click New Query >  Paste the following query:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE NodesData set Vendor = 'Your_Vendor_Name_Here' where ip_Address = 'Your_Node_IP_ADDRESS_Here' 

        4. Click Execute Query. 

 

For example:

 

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE NodesData set Vendor = 'MY-ISP-NODE' where ip_Address = '192.168.1.130' 

 

 

If you wish to update the Machine Type/ICON/GIF, use below SQL query.

Change the Query according to your needs. 
 

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

UPDATE NodesData set Vendor = 'Cisco' where ip_Address = '8.8.8.8' 
UPDATE NodesData set SysObjectID = '1.3.6.1.4.1.9.1.186' where ip_Address = '8.8.8.8' 
UPDATE NodesData set MachineType = 'Cisco 2611' where ip_Address = '8.8.8.8' 
UPDATE NodesData set Vendoricon = '9.gif' where ip_Address = '8.8.8.8' 

 

NOTE:
You can find the vendor icon in this location. You may add your own vendor icon here.

C:\Program Files (x86)\SolarWinds\Orion\Graphics\Vendors