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
agents = [ “10.19.100.1” ]
version = 2
community = "test"
name = "switches"
timeout = "5s"
retries = 3
name = "sysName"
oid = "SNMPv2-MIB::sysName.0"
is_tag = true
name = "sysUpTime"
oid = “SNMPv2-MIB::sysUpTime.0”
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.