# Grafana + InfluxDB + Telegraf

**URL:** <https://community.grafana.com/t/grafana-influxdb-telegraf/7606>\
**Category:** InfluxDB\
**Created:** [May 22, 2018, 1:55pm UTC](https://community.grafana.com/t/grafana-influxdb-telegraf/7606 "2018-05-22T13:55:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![renegade310](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/renegade310/32/2758_2.png) [@renegade310](https://community.grafana.com/u/renegade310)\
**Post date:** [May 22, 2018, 1:55pm UTC](https://community.grafana.com/t/grafana-influxdb-telegraf/7606/1 "2018-05-22T13:55:46Z")

</div>

Hello. I try to monitor network traffic from device D-link DGS-3420-28TC.  
Looks good, but I want an opportunity to check devices interfaces manualy from the table,so I use variables.  
I make it, but it didnt make changes, when I check one or two interfaces:

 ![2](https://us1.discourse-cdn.com/grafana/original/2X/3/38497c8dc731721832473cc6e40736764b0c5560.png)

Config of variable:

 ![3](https://us1.discourse-cdn.com/grafana/original/2X/6/604e47ee530788088e0cbe5016f3646a057ded10.png)

And my InfluxDB query looks like that:

```auto
SELECT derivative(mean("ifHCInOctets"), 1s) *8 AS "Input", derivative(mean("ifHCOutOctets"), 1s) *8 AS "Output" FROM "autogen"."interface" WHERE $timeFilter GROUP BY time($__interval), "ifDescr" fill(null)
```

---

<div class="post-metadata">

**Author:** ![samaust](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/samaust/32/2792_2.png) [@samaust](https://community.grafana.com/u/samaust)\
**Post date:** [July 1, 2018, 11:23pm UTC](https://community.grafana.com/t/grafana-influxdb-telegraf/7606/2 "2018-07-01T23:23:47Z")

</div>

I think you forgot to filter and it should be

```auto
SELECT derivative(mean("ifHCInOctets"), 1s) *8 AS "Input", derivative(mean("ifHCOutOctets"), 1s) *8 AS "Output" FROM "autogen"."interface" WHERE "ifDescr" =~ /^$Interfaces$/ AND $timeFilter GROUP BY time($__interval), "ifDescr" fill(null)
```