SELECT query returns empty series

[Rogelio_Alvez]

Hello team:
The following query returns me the contents of two series in my database: The tag of each series is the interface name (ifName) of a Cisco Switch:

SELECT max(“ifHCInOctets”) FROM “interface” WHERE “hostname” = ‘SW-AR-CD-CBA-011’ AND time>=now()-1h GROUP BY ifName, time(5m) fill(null)
name: interface
tags: ifName=Gi1/0/25
time max

---

2023-12-04T18:50:00Z 48354178426
2023-12-04T18:55:00Z 48355855467
2023-12-04T19:00:00Z 48357406516
2023-12-04T19:05:00Z 48359095814

name: interface
tags: ifName=Gi1/0/26
time max

---

2023-12-04T18:50:00Z 2217425915
2023-12-04T18:55:00Z 2217602923
2023-12-04T19:00:00Z 2217743693
2023-12-04T19:05:00Z 2217903465

Now I want to go a bit deeper and query the series whereby ifName is equal to “Gi1/0/25”. Now influxDB returns me nothing. I tried many combinations without success:

SELECT max(“ifHCInOctets”) FROM “interface” WHERE “hostname” = ‘SW-AR-CD-CBA-011’ AND ifName=‘Gi1/0/25’ AND time>=now()-1h GROUP BY time(5m) fill(null)
SELECT max(“ifHCInOctets”) FROM “interface” WHERE “hostname” = ‘SW-AR-CD-CBA-011’ AND “ifName”=‘Gi1/0/25’ AND time>=now()-1h GROUP BY time(5m) fill(null)
SELECT max(“ifHCInOctets”) FROM “interface” WHERE “hostname” = ‘SW-AR-CD-CBA-011’ AND “ifName”=“Gi1/0/25” AND time>=now()-1h GROUP BY time(5m) fill(null)
SELECT max(“ifHCInOctets”) FROM “interface” WHERE “hostname” = ‘SW-AR-CD-CBA-011’ AND “ifName”=Gi1/0/25 AND time>=now()-1h GROUP BY time(5m) fill(null)
SELECT max(“ifHCInOctets”) FROM “interface” WHERE “hostname” = ‘SW-AR-CD-CBA-011’ AND ifName=Gi1/0/25 AND time>=now()-1h GROUP BY time(5m) fill(null)
SELECT max(“ifHCInOctets”) FROM “interface” WHERE “hostname” = ‘SW-AR-CD-CBA-011’ AND ‘ifName’=‘Gi1/0/25’ AND time>=now()-1h GROUP BY time(5m) fill(null)

¿ Am I missing something here?

show series from “interface” where “hostname”=‘SW-AR-CD-CBA-011’
key

---

interface,agent_host=10.133.38.12,hostname=SW-AR-CD-CBA-011,ifAlias=[TRUNK],ifName=Gi1/0/25,index=10125,sitecode=AR-CD-CBA,template=Switch-L2
interface,agent_host=10.133.38.12,hostname=SW-AR-CD-CBA-011,ifAlias=[TRUNK],ifName=Gi1/0/26,index=10126,sitecode=AR-CD-CBA,template=Switch-L2

Any help will be greatly appreciated.
Best regards, Rogelio

root@96b453224bc7:/# influx --version
InfluxDB shell version: 1.7.9

[Rogelio_Alvez]

I made it work! I followed the solution in this link:

Unable to view individual switch interfaces. Is this a tag misconfiguration?

Hello @DeMoB , Are you able to return data if you do: SELECT derivative(mean("ifHCInOctets"), 1s) /1000000*8 AS "In", derivative(mean("ifHCOutOctets"), 1s) /1000000 *-8 AS "Out" FROM "snmp" WHERE ("hostname" = 'Server-Room-C-POE') AND $timeFilter GROUP BY time($interval) With no fill? I can’t see why adding a fill null would not allow you to view the results especially if you can select for all those values. Does this work? SELECT "ifHCInOctets"FROM "snmp" WHERE ("hostname" = 'Server-Room-…

Basically, I had to add the ::tag qualifier to ifName and use single quotes in the interface ID:

SELECT max(“ifHCInOctets”) FROM “interface” WHERE (“hostname”=‘SW-AR-CD-CBA-011’) AND (ifName::tag=‘Gi1/0/25’) AND time>=now()-10m GROUP BY time(5m)
name: interface
time max

---

2023-12-05T11:45:00Z
2023-12-05T11:50:00Z 48693265498
2023-12-05T11:55:00Z 48694643333