A solution would be to create a Custom Node Property that contains the Vendor name.
Instead of having an empty field for the ICMP devices you can use the below SQL command to update all of them at once:
SET CustomPropertyFieldName = 'NONSNMP'
WHERE ObjectSubType = 'ICMP'
To update the SNMP nodes, you can use Database Manager and copy/paste the initial field information to the Custom Property.
You will then be able to sort your nodes using the custom property instead of the default vendor field.
Note that if you try to automatically edit the Vendor column, changes will be overwritten after sometimes hence the Custom Node Property requirement.
I had a similar question; "How Can I Assign I Vendor or Machine Type to the HSRP IP Address that is just being Polled?"
Answer Provided by SolarWinds Trainer; Ed Barbieri
- URL https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/Assign_a_vendor_to_an_ICMP_node
Within this SolarWinds Success Centre Information you will see that this can be done by editing the NodesData via the SolarWinds Database Manger.