cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

F5 OID - Table - First 5 rows only?

Jump to solution

Im polling a OID in F5, and it comes back with multiple tabular values. I see that Solarwinds takes only the first 5 rows into consideration? I have all my important values after the 5th row. There are many rows with 0. Is it possible to exclude all ZERO rows, and have only the important values to be shown in report?

Here is the OID:

1.3.6.1.4.1.3375.2.6.1.1.3.1.5

access0 
_tmm_apm_acl0 
/Common/access0 
/Windows/xenapp.app/citrix0 
/Windows/xenapp.app/citrix0 
/Common/duo_xx_hst_chk0 
/Common/duo_xx_hst_chk149Browser VPN
/Common/duo_xx_hst_chk0 
/Common/duo_yy.xx.org0 
/Common/duo_yy.xx.org0 
/Common/duo_yy.xx.org2VPN Basic
/Common/duo_yy.xx.org_basic0 
/Common/duo_yy.xx.org_basic0 
/Common/duo_yy.xx.org_basic0 
/Common/duo_f5client0 
/Common/duo_f5client2001Thick Client
/Common/duo_hst_avchk-temp69 
/Common/20200323-duo0 
/Common/yy.xx.org_basic0 
/Common/xxvpnhostchk_f5client0 

 

Only 3 values in the above table are useful. How do I extract those?

Regards

0 Kudos
2 Solutions

You set the label when you were creating the UNDP, it had a prompt on maybe the 4th screen if i recall correctly. Anyway you can just change it by loading the UNDP tool, find your poller right click and go to label

mesverrum_1-1585337438373.png

 

1, Change the radio button from the default value of interfaces

2, find your vendor and the device you want to use to test the OID, click test

3, the columns will populate based on what your device sends back you pick the column number that would be the best for your row labels.  It is not always the first one, in my example here column 6 actually had the friendly names I wanted to use for my table.

4, click finish, wait for the next polling cycle to complete then refresh your chart and the labels should line up.

mesverrum_0-1585337409779.png

 

It is relatively uncommon, but there are cases where the labels you want aren't on the same table as the data you want to chart out and that gets a lot more complicated there because Orion just natively assumes the labels live on the same table.  In these cases if you dig around in the SNMP trees for your gear enough and can actually find the table with the names you want to use and they are organized using the same row id scheme as the table you are polling then you can actually edit the database and manually set the OID orion uses to find labels to anything you want.  As usual, be careful when you are in there hacking the database up, but I have done this in many cases for clients and it is pretty low risk as long as you know not to accidentally overwrite the labels column for the whole table or some other similar mistake.

mesverrum_2-1585337952386.png

 

* Despite the fact that labeltype says sametable, you can actually give it any OID as long the the rowid scheme is the same between both tables.

- Marc Netterfield, Github

View solution in original post

For a node summary view I personally usually use the custom chart widget with custom swql data source because i find that the OOTB widgets are kind of inferior for this, but the built in option for this use case is the Multiple Universal Device Pollers Chart widget.

You pick your UNDP, select the nodes that it is assigned to and then you should get something like this:

mesverrum_0-1585694699541.png

 

- Marc Netterfield, Github

View solution in original post

15 Replies
MVP
MVP

Why do you think it only considers the first 5 rows?

It tells me when I add it to a custom poller. First 5 rows are 0. It also gives me an error trying to add that OID.

s seen below, it says First 5 rows. I cant see the other values in the graph using regular poller (thro GUI).

Will UnDP help in this case? Im going to try UnDP later this week. 

Regardsf5 oid.png

0 Kudos
Yes this is a use case for a UNDP
- Marc Netterfield, Github

Ok.. I added this in UnDP. I get a lot of wrong/garbage data. It shows some random numbers as given below..

I selected the SNMP MIB Value as RAW. When I ran a SNMP Walk to the OID, it showed it as a Counter. Should I change the SNMP MIB value in UnDP to Counter instead ? and use GET TABLE, instead of GET NEXT? 

apmpastatus.jpg

Please see the output of the SNMP Walk i did..

At the bottom i see the variable type as counter.. SHould I use counter instead of RAW in UnDP ? Also , the number shown doesnt match the graph 😞 

APMCOunter.jpg

 

0 Kudos

anyone has any ideas? Im planning to open a TAC case for this

0 Kudos
Those long strings instead of names are because you selected the wrong info for your label.

As far as the numbers not matching the graph it's likely because you are showing a full day on the graph, they automatically smooth out data points when you try to show too many at once. Change your graph to something like last hour and set the graph interval to match the poll interval and I expect it will align.
- Marc Netterfield, Github

Those long strings instead of names are because you selected the wrong info for your label. - Where do we select this? and can I edit it to the show the correct info?

0 Kudos

You set the label when you were creating the UNDP, it had a prompt on maybe the 4th screen if i recall correctly. Anyway you can just change it by loading the UNDP tool, find your poller right click and go to label

mesverrum_1-1585337438373.png

 

1, Change the radio button from the default value of interfaces

2, find your vendor and the device you want to use to test the OID, click test

3, the columns will populate based on what your device sends back you pick the column number that would be the best for your row labels.  It is not always the first one, in my example here column 6 actually had the friendly names I wanted to use for my table.

4, click finish, wait for the next polling cycle to complete then refresh your chart and the labels should line up.

mesverrum_0-1585337409779.png

 

It is relatively uncommon, but there are cases where the labels you want aren't on the same table as the data you want to chart out and that gets a lot more complicated there because Orion just natively assumes the labels live on the same table.  In these cases if you dig around in the SNMP trees for your gear enough and can actually find the table with the names you want to use and they are organized using the same row id scheme as the table you are polling then you can actually edit the database and manually set the OID orion uses to find labels to anything you want.  As usual, be careful when you are in there hacking the database up, but I have done this in many cases for clients and it is pretty low risk as long as you know not to accidentally overwrite the labels column for the whole table or some other similar mistake.

mesverrum_2-1585337952386.png

 

* Despite the fact that labeltype says sametable, you can actually give it any OID as long the the rowid scheme is the same between both tables.

- Marc Netterfield, Github

View solution in original post

Big thanks to you on the LABEL. I was able to see the label assignments from UnDP, and changed it . I no more see the garbled assignments. 

 

Thanks so much. Im working on this for a final solution 🙂

 

Ok.. Im almost there 🙂  I got UnDP access, and Im able to table/chart the OIDs in question... everything looks good, except the place where this report is shown.

I created a new view (summary view), and Im able to do all custom UnDP reports here. 

In UnDP, in web assign tab , when I try to assign the OID charts, I dont see my Summary view page (greyed out) - possibly because it expects Node view. I created a new Node View, and I can see it in Web assign through UnDP, but I cant see the new View in the Dashboard I created 😞 

How do we push the UnDP reports to a summary view? I promise, my last question 🙂 

0 Kudos

For a node summary view I personally usually use the custom chart widget with custom swql data source because i find that the OOTB widgets are kind of inferior for this, but the built in option for this use case is the Multiple Universal Device Pollers Chart widget.

You pick your UNDP, select the nodes that it is assigned to and then you should get something like this:

mesverrum_0-1585694699541.png

 

- Marc Netterfield, Github

View solution in original post

Marc

Appreciate all your expert comments on this one. 

I atlast have what i want 🙂 pushed UnDP reports to Node properties, and exported that as a custom URL to the Dashboard. Works great and all reports looks good ! I couldnt play much with Database queries. Hopefully ill learn that soon 🙂

Thanks again

 

0 Kudos

I also just jumped back to the beginning of the thread where your initial question was that you only really wanted 3 of the values from this whole table anyway. Just figure out what row you want to poll and stick that on the end of the OID

So if we are starting with this to get the whole table: 1.3.6.1.4.1.3375.2.6.1.1.3.1.5

but you only need rows 7, 11, and 16 then make 3 custom pollers, probably doing a get next on them.

1.3.6.1.4.1.3375.2.6.1.1.3.1.5.7

1.3.6.1.4.1.3375.2.6.1.1.3.1.5.11

1.3.6.1.4.1.3375.2.6.1.1.3.1.5.16

Thats honestly going to be a lot cleaner than pulling the whole table

- Marc Netterfield, Github

When I tried doing a SNMP poll :

No results for "1.3.6.1.4.1.3375.2.6.1.1.3.1.5.7" in all fields.

Search suggestions:

  • Remove the last digit from an OID to find the branch in the MIB tree, then drill down to the specific OID.
  • If the OID does not exist in our database, you can manually define the OID below.
  • Search the thwack community for useful OIDs.


Should I add this OID manually and then try? Im doing this SNMP poll from the MIB browser tab in Solarwinds GUI. Ill try through UnDP too and let you know.

Raj

0 Kudos
The mib browser only works for a very limited subset of possible OID's at this point, basically just to replace the ones Orion uses to calculate CPU/Mem as far as stats go, or to get strings for things like the vendor/machinetype/description. For anything you need to track stats on (except cpu/mem) you will only be able to make it happen in the UNDP tool.
- Marc Netterfield, Github