> This table has 15 columns and 65 rows.

That sound similar to ifTable/ifXTable in IF-MIB.

> Each row represents a "sub-device"

That sounds similar to "interfaces" on a network device. Is there some 
column which can be used to identify the sub-device, similar to 
ifName/ifDescr/ifAlias?

> Ideally, I'd like to create some kind of time series graph for each 
metric/column, each of which has lines for each device/row.

Like plotting graphs for ifHCInOctets, ifHCOutOctets, ifErrors etc.  See if 
you can model on that.

As for enums, there's some info here:
https://github.com/prometheus/snmp_exporter/blob/v0.23.0-rc.1/generator/README.md#enumasinfo-and-enumasstateset

You'd use EnumAsStateSet only if you want a single SNMP data point to be 
exploded into N different timeseries, one for each possible value. e.g. 
suppose you have a single enumerated value for the status of a UPS, it 
could expand to

apcups_status{status="online"} 0
apcups_status{status="onbatt"} 1
apcups_status{status="trim"} 0
apcups_status{status="boost"} 0
apcups_status{status="overload"} 0
...etc

EnumAsInfo will apply a single label which changes (therefore, if it ever 
changes, the timeseries will change; only use this for labels which are 
essentially static).  Alternatively, you could represent enums as a plain 
integer stored as a numeric metric, and then in Grafana you map each 
integer value to a different label and/or colour.

On Saturday, 5 August 2023 at 08:13:01 UTC+1 Ben Kochie wrote:

> What you need is to take the device MIB and use the SNMP exporter's 
> generator to translate the table into metrics. Unfortunately, Adder 
> Technology doesn't seem to have their MIB publicly available, so I can't 
> see what it specifies in the table.
>
> On Sat, Aug 5, 2023 at 3:42 AM 'Elliott Balsley' via Prometheus Users <
> [email protected]> wrote:
>
>> I've just started using Grafana and Prometheus with SNMP Exporter.  My 
>> Adder AIM server provides SNMP data in a table format, which is very hard 
>> to comprehend in Grafana.  Is there some recommended way to handle this 
>> type of data?
>> This table has 15 columns and 65 rows.  Each row represents a 
>> "sub-device", or an Adder KVM endpoint.  Attached is a screenshot from the 
>> open-source SnmpB app showing it nicely.
>>
>> The data comes into Prometheus looking like this (just a few lines 
>> example), with each metric on a separate line:
>> # HELP deviceEth1Status Status of eth1 interface - 
>> 1.3.6.1.4.1.25119.1.1.1.30 (EnumAsStateSet) # TYPE deviceEth1Status gauge 
>> deviceEth1Status{deviceEth1Status="absent",deviceIndex="1"} 0 
>> deviceEth1Status{deviceEth1Status="absent",deviceIndex="101"} 0 
>> deviceEth1Status{deviceEth1Status="absent",deviceIndex="1101"} 0 
>> deviceEth1Status{deviceEth1Status="absent",deviceIndex="1201"} 0 
>> deviceEth1Status{deviceEth1Status="absent",deviceIndex="1301"} 0 
>> deviceEth1Status{deviceEth1Status="absent",deviceIndex="1401"} 0 
>> deviceEth1Status{deviceEth1Status="absent",deviceIndex="1501"} 0
>>
>> It also includes dozens of extra "rows" for devices which don't actually 
>> exist. 
>> Ideally, I'd like to create some kind of time series graph for each 
>> metric/column, each of which has lines for each device/row.
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "Prometheus Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to [email protected].
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/prometheus-users/fc2aceb2-6b45-4c8f-9297-eee882bdf8acn%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/prometheus-users/fc2aceb2-6b45-4c8f-9297-eee882bdf8acn%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/prometheus-users/3f83a84d-2fb1-4320-afeb-5d6b088d750en%40googlegroups.com.

Reply via email to