Is there a way to auto force a specific PreferredCiscoMIB automatically?

stevenstadel

Our default PerferredCiscoMIB is CISCO-ENTITY-SENSOR-MIB, which is the platform default. We have found that our new Cisco 9200 models are showing temperature warnings with that MIB, but switching to CISCO-ENVMON-MIB doesn't show the warning error. 

Is there a way to auto-assign the other CISCO-ENVMON-MIB based on a specific model? I have a SWQL query that I can use if there is a way to determine if the PerferredCiscoMIB is assigned. I am looking for a way to set this via the REST API. SELECT N.NodeID, N.Caption, N.IPAddress,
N.MachineType,
N.HardwareHealthInfos.Model,
N.IOSVersion,
(SELECT SettingValue FROM Orion.NodeSettings WHERE (NodeID = N.NodeID AND SettingName = 'HardwareHealth.PreferredCiscoMIB')) AS PreferredCiscoMIB
FROM Orion.Nodes AS N
WHERE N.Category = 1
AND N.HardwareHealthInfos.Model like 'C9200CX-12P-2X2G'
AND N.Vendor = 'Cisco'
ORDER BY N.Caption

mesverrum

I don't have my hands on a live orion environment right now to see the exact commands, but from the swagger docs the orion.nodesettings table does allow crud operations so i expect that you would either need to update or create the HardwareHealth.PreferredCiscoMIB values that youve got in your query.

I know I did something similar to this in my last environment, but I was using db triggers directly so that any time anyone added or edited node setting values it would lock everything back to what I wanted it to be.  This was just one of a dozen checks I had built into my db to stop people from breaking things.

- Marc Netterfield

•     Loop1: SolarWinds Training and Professional Services
•     GitHub: Mesverrum