How to get the First Row from a Manage Pollers poller

I'm creating a Machine Type Poller that gets the model number, but the model Number only can be found in a SNMP table. Per the instructions in the screenshot below it says I have to create a calculated value:

pastedImage_0 - Copy.png

However, the calculated values are things like Average, Sum, and Count. I found you can also use Max (it's not documented, but it works. I wonder what else works but isn't documented. Really Solarwinds??), but there are no good examples in the Manage Pollers screen nor the help documentation. Even the "Common Formulas" page is really really weak when it comes to giving examples. There should be a clear example of each type of calculation formula. Currently that page is just a list of formula names with very brief and unhelpful descriptions of what they do. Just add an example beside each description. Why would you not do that in the first place?? How frustrating is this to have this new feature and not have it adequately documented?!?)

This shouldn't be this difficult. I've been playing with it forever now and I can not get the stupid thing to just take the top row. I just want it to return the top row of this table as the value and it seems impossible. Please someone tell me what I'm missing and please SolarWinds make this easier. There is zero reason for it to be this hard.

Find more posts tagged with

manage pollers

custom pollers

device studio

pollers

Accepted answers

mesverrum

If you scroll to the bottom of the screen you showed you will have a button that says something like "Not finding your OID?" and it lets you set up a custom OID. In this case you will want to set up a custom OID for 1.3.6.1.4.2.1.47.1.1.1.1.13.1 which will pull the first row of the table. You may have to experiment with the Get type, but i believe a Get Table will be correct. Let me know if this gives you any trouble but I suspect you will find what you are looking for. No need to bother with calculated values at all.

This is the kind of thing you probably would only stumble upon if you spent way too much time from your life digging through SNMP walks of strange devices building your own completely custom pollers unfortunately.... Better documentation would probably help but life is rarely what we want

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

All comments

njoylif

I'm wondering how to get the table back, like you could in the app version...I need to monitor physicalDisks on F5s and there are a mix of single and multiple drives.

mesverrum

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

xtraspecialj

I ended up discovering this on my own, but I'll mark your answer as correct since you posted it before I edited my comment to include this, and that's assuming I ever would have remembered to do so. I really wish they would just add a function that lets you pick a row from a table based on the row number, row position, or using the conditional function to pick a row based on what it may contain. Maybe I'll create a feature request for this.

njoylif

mesverrum, when you pull "get table" from GUI, I get issue where "this object requires a single value"

Is there a way to pull the whole table or do I have to break out?

TIA for your help!

xtraspecialj

There is no way to pull the whole table. It will always expect a single value, so what mesverrum's fix is saying is you will need to put the full OID for each and every row of a table that you want to pull data from. This means browsing the table to see what each Row ID is and adding that to the end of the table OID. It's a pain in the butt...

njoylif

thanks for response. I figured...

aline.eid

xtraspecialj

how did you concatenate them? "This means browsing the table to see what each Row ID is and adding that to the end of the table OID".

I am working on node red, and I need to concatenate the row index with the oid to get the info.