Assign a vendor to an ICMP node

Overview

This article describes how to assign a vendor to an ICMP node added in Orion . Since the nodes are only added with ICMP, therefore no vendor is detected. 

Environment

All NPM and Core versions 

Steps

Notes:

• This will not work with nodes added via SNMP.
• See this Thwack post if you have nodes added in Orion with SNMP credentials and are stil. recognized as unknown for the vendor.

1. Go to Start > All Programs > Solarwinds Orion > Advanced Features > Database Manager > Add Default Server>.
2. Right click on the the NPM Database (default) NetPerfmon >
3. Click New Query >  paste the following query:
   update Nodes set Vendor = 'Your_Vendor_Name_Here' where ip_Address = 'Your_Node_IP_ADDRESS_Here' 
4. Click Execute Query. 

For example: 

update Nodes set Vendor = 'MY-ISP-NODE' where ip_Address = '192.168.1.130' 

You can then change the IP Address in order to update the table for each node.

Now if you wish to update / Machine Type / ICON / Gif use the below SQL Queries example. 

Change the Query according to your needs. 

update Nodes set Vendor = 'Cisco' where ip_Address = '8.8.8.8' 

update Nodes set SysObjectID = '1.3.6.1.4.1.9.1.186' where ip_Address = '8.8.8.8' 

update Nodes set MachineType = 'Cisco 2611' where ip_Address = '8.8.8.8' 

update Nodes set Vendoricon = '9.gif' where ip_Address = '8.8.8.8' 

Please Note: 

You can find the vendor icon under below directory or can add your own vendor icon here . 

C:\inetpub\SolarWinds\NetPerfMon\images\Vendors

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

we do have a lot of vendors which do not have a real image/icon
nothing new  the collection is being updated each release  any customer can create own one and update therefor this is placed in the DB and have no real images provided.