Add description interfaces with second variable?

Hello grafana community.
Can you help me with this problem?
I have several switches, I want a dashboard for each switch.
I want to repeat panels by interface (variable) and I want to show in each panel the name of the interface and the description.

I saw in a post that you suggested extract the description with MySQL, I have already tried everything and I can not show what I ask.

I leave the configurations so you can guide me.

$switch
SHOW TAG VALUES WITH KEY =~ /agent_host/

interface SHOW TAG VALUES WITH KEY =~ /ifName/ WHERE agent_host =~ /^[[switch]]/

$alias (MySQL)
SELECT CONCAT(ifname," “,ifalias) FROM data WHERE ip in(”$switch") AND ifalias in(ifAlias)

Series(example 10 lines)
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/1
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/2
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/3
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/4
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/5
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/6
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/7
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/8
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/9
snmp,agent_host=192.168.1.204,host=monitor-ar,hostname=sw-ar-04,ifName=Fa0/10

Telegraf
[[inputs.snmp]]
agents = [ “192.168.1.204” ]
version = 2
community = “public”
interval = “60s”
timeout = “10s”
retries = 3

[[inputs.snmp.field]]
name = “hostname”
oid = “RFC1213-MIB::sysName.0”
is_tag = true

[[inputs.snmp.table]]
name = “snmp”
inherit_tags = [ “hostname” ]
#oid = “IF-MIB::ifXTable”

[[inputs.snmp.table.field]]
name = “ifName”
oid = “IF-MIB::ifName”
is_tag = true

[[inputs.snmp.table.field]]
oid = “IF-MIB::ifHCInOctets”

[[inputs.snmp.table.field]]
oid = “IF-MIB::ifHCOutOctets”

MySQL
table (hosts)
select * from hosts where ip=‘192.168.1.204’;
±---------------±----------±---------+
| ip | community | name |
±---------------±----------±---------+
| 192.168.50.204 | public | sw-ar-04 |
table (data)
select * from data;
±---------------±-------±-----------------------------------------+
| ip | ifname | ifalias |
±---------------±-------±-----------------------------------------+
| 192.168.1.204 | Fa0/1 | link corporate |
| 192.168.1.204 | Fa0/2 | link corporate2 |
| 192.168.1.204 | Fa0/3 | link corporate3 |
| 192.168.1.204 | Fa0/4 | box1 |
| 192.168.1.204 | Fa0/5 | box2 |
| 192.168.1.204 | Fa0/6 | box3 |
| 192.168.1.204 | Fa0/7 | box4 |
| 192.168.1.204 | Fa0/8 | box5 |
| 192.168.1.204 | Fa0/9 | box6 |
| 192.168.1.204 | Fa0/10 | box7 |

Use Grafana v6.0.1
How can I repeat panels for variable $interface and show the variable $alias in the panel title?

Regards

Hey any luck on this one? I just encountered the same issue…

I am unclear on what you are asking for help with, but I am a SQL noob.

Is there a reason you can’t just use a Repeated panel?