I've been importing a load of CheckMK data into Influx via the Exec plugin in Telegraf. I've 'translated' the checkmk data into Influx Line Protocol, and it looks something like this:
checkmk,service=nginx_threads ActiveConn=67,reading=0,writing=4,waiting=63,status=0,message="OK - ActiveConn:67 reading:0 writing:4 waiting:63" checkmk,service=process_bacula-client vss=421752,rss=2140,cpu=0.0,mem=0.1,status=0,message="Process bacula-client running with PID 19790" checkmk,service=process_telegraf vss=1159592,rss=19968,cpu=0.0,mem=0.6,status=0,message="Process telegraf running via systemd with PID 15131" checkmk,service=deleted_open_files total_mb=0.00,pids_with_files=0,status=0,message="0 bytes: Top 0 hogs:" I've been able to graph different things, but am trying to generalise a bit. What I'm looking to do is let the user select 'Host', 'Service' and then the particular stat they want. I've got suitable template variables to pick a host and one of the services on it. but can't get the field names. Looking here and in the doco, there's no way to do WHERE clauses on SHOW FIELD KEYS queries. The best I have is to get a complete list of all the fields in the 'checkmk' measurement, but that means you can select something that the host you chose doesn't have on it. I'm free to change anything about the data I'm putting into Influx, and I can obviously use any query in Grafana to get data out. Is there a way I can restructure what I'm doing to get a sub-set list of field names? -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/80ccb420-e7fe-416e-a0b9-ad8642db862a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
