How to manually create Vendor groups?

Good morning Thwackers!
Some of our managed (ICMP) infrastructure cannot be discovered via SNMP - and therefore these devices end up in the Unknown vendor group. As admins of our infrastructure we know what these devices are - but need assistance manually creating vendor groups so that the Dashboard Summary page lists the manually created vendor groups along with vendor groups that are auto-created via information gained from SNMP and/or credentialed access.
Respectfully,
Peter Rounds
Senior Network Engineer

Hi phrounds8002.

I had a similar issue and got the following help on it.

1. On the primary polling engine open Database Manager and add the Orion Sever.

2. Expand out SolarWIndsOrion and run a new query against NodesData

3. For my scenario all the nodes start with (PSBA) so I run the following
    SELECT * FROM [dbo].[NodesData]
    WHERE Vendor LIKE '%unknown%' AND Caption LIKE '%PSBA%'

4.This lists the nodes I need to change Vendor for.

5. Then i needed to run the following to change the Vendor for the node.
    UPDATE NodesData SET Vendor = 'PSBA' WHERE IP_Address in(
    '1.1.1.1')

CHANGE IP FOR NODE YOU WANT TO CHANGE

Hoe this helps.

If anyone can expand on this to change multiple nodes at the same time that will help save you some time

MarkyB

Don't forget to back up your Database before making any changes :)