I am trying to create a new poller that will get me the actual model of a cisco device instead of the generic model. EX. im getting 3560 and i need it to display WS-C3560X-24P-S.
I found the OID that gives me the desired result but I cannot click where it says "Yes, The data source is reasonable" because at the top it says
" You need to transform the multiple values into a single value or select a different OID. Orion expects a single String in for MachineType. The selected data source returns multiple values."
I have looked at the formula page on here and all related links on the solarwinds site and I still don't know what I need to enter to be able to create this.
Here is the OID in case you want to see the message also: 184.108.40.206.220.127.116.11.18.104.22.168
Anyone dealt with this or know what I need to enter to get to create this poller?
This exact issue has been solved previously. I've added the link to that post below. I tested on my system and works fine.
In addition to that solution, this is how i do it. If you use NCM in your environment, you can also query the column "Model" in the table "Orion.HardwareHealth.HardwareInfoBase" or in SWIS the shortcut Orion.Nodes.HardwareHealthInfos.Model for this same data.
When I do most of my queries I do something like:
SELECT ISNULL(n.HardwareHealthInfos.Model, n.MachineType) as Model
FROM Orion.Nodes n
This looks in the Model column and uses that value assuming it isn't blank, if it is blank it uses the standard Model field from NPM.
I also have this problem with NEC Microwave Radios. The SysName (and contact/location etc) is presented as a Table with 1 row. I cannot find an example anywhere about how to select just the first row. Any help would be great if you managed to fix your problem.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.