Cannot filter by _value in SNMP Tables data

InfluxDB 2
,
1

I have snmp table data coming into a bucket and I am trying to filter by the _value column but in doing so I always get “No Results” even though the data is there. I can filter by any other column like _field or host that shows in the main results but never from _value. I even tried to grab the main data set and push it into a new bucket and assigning the results of _value to a new column of a different name and filtering on that column also gives “No Results”.

Can someone give some insights as to why data that I can see exists cannot be filtered like the other columns can?

2

Hello @R0bR,
What is the query that you’re using?
And what is the type of your _value column?

3

Hello @Anaisdg ,

It’s a pretty basic query…

from(bucket: "InfluxDB_Server")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Volume")
  |> drop (columns: ["_start", "_stop", "_measurement", "host"])
  |> filter(fn:(r) => r.agent_host == "nas-01" and r._field == "volumeTableDescription")

This basically gives me a list of volume names that are mounted on the host nas-01 in the _value column, but I don’t want all the volumes I want a specific volume by name but when I add…

|> filter(fn:(r) => r._value == "Volume_1")

It returns No Results even though the volume “Volume_1” IS on the list of volumes returned.

This is the Raw Data showing in Influx, type is string.

RAW_Data
RAW_Data854×209 45.7 KB

4

Hello @R0bR,
That looks like a bug to me.
Can you please create an issue?

Thanks!

5

Hi @Anaisdg,

I did last November with no response to it.

Cannot filter by column when data is from snmp.tables · Issue #22941 · influxdata/influxdb (github.com)

Going to add additional info like I posted here for more clarity.

6

I just realized your link goes to the Influxdata/Flux Github page, mine is just to Influxdata.

7

@Anaisdg , I figured it out. I had to filter with a string search to match the name of the volume I wanted to isolate.

|> filter(fn: (r) => (strings.containsStr(v: r["_value"], substr: "Volume_1")))

Now I have an issue where I have a Volume_1 and Volume_1_1 in the mix but only want to filter Volume_1. Because that exists as part of Volume_1_1 they both show. Is there a way to incorporate a NOT in the filter so match Volume_1 but not Volume_1_1?

1 Like
8

@R0bR Thanks for sharing your solution!!!