Templating Non-Tagged values - InfluxDB/Grafana/Telegraf

Hello all,

You’ll have to excuse me as I’m just getting started with tick/grafana so my questions may seem a bit off.

I’m looking to template non-tagged values from a telegraf query and I’m having a hard time figuring this one out.

Here’s what I have:
Telegraf v1.4.4 (git: release-1.4 ddcb93188f3fb5393d811cdd742bfe6ec799eba9)
Grafana Version 4.6.2 (commit: 8db5f08)
InfluxDB version: 1.3.7

I’m running a telegraf query like so (taken from telegraf.conf):

# Retrieves SNMP values from local infrastructure switches

[[inputs.snmp]]
agents = [ “10.19.100.1” ]
version = 2
community = "test"
name = "switches"
timeout = "5s"
retries = 3

sysName

[[inputs.snmp.field]]
name = "sysName"
oid = "SNMPv2-MIB::sysName.0"
is_tag = true

sysUpTime

[[inputs.snmp.field]]
name = "sysUpTime"
oid = “SNMPv2-MIB::sysUpTime.0”

sysLocation

[[inputs.snmp.field]]
name = "sysLocation"
oid = “SNMPv2-MIB::sysLocation.0”

Upon running this, I get back what I’d expect:
switches,sysName=switchname,agent_host=10.19.100.1,host=influxdb-02 sysUpTime=2238248503i,sysLocation=“Location” 1517879190000000000

I’d like to create a variable relating to sysLocation but I can’t figure out how to access it.

I’ve been able to create a sysName variable using this syntax: SHOW TAG VALUES WITH KEY = “sysName”, and things are looking good.

I’ve created a template called ‘measurements’ which returns all measurement values from the db but I can’t seem to get to the non-tagged data within ‘switches’.

Would anybody have any information that can help me achieve this.

Also, on a side note, I’ve done quite a bit of troubleshooting/googling on this and I keep finding snippits of things like:
SHOW MEASUREMENTS WHERE name =~ /.some regex./
SHOW MEASUREMENTS FROM /.some regex./

But I can’t find a definitive page that shows all my options for these particular queries.

My apologies if this is long-winded, just trying to get some clarification.

Thank you in advance for your help and support.

Cheers,

Mike