docs-v2/content/influxdb/v2/visualize-data/variables/common-variables.md

3.3 KiB

title description menu weight influxdb/v2/tags
Common variable queries Useful queries to use to populate values in common dashboard variable use cases.
influxdb_v2
parent name
Use and manage variables Common variable queries
208
variables

List buckets

List all buckets in the current organization.

Flux functions: buckets(), rename(), keep()

buckets()
    |> rename(columns: {"name": "_value"})
    |> keep(columns: ["_value"])

List measurements

List all measurements in a specified bucket.

Flux package: InfluxDB schema
Flux functions: schema.measurements()

import "influxdata/influxdb/schema"

schema.measurements(bucket: "bucket-name")

List fields in a measurement

List all fields in a specified bucket and measurement.

Flux package: InfluxDB schema
Flux functions: schema.measurementTagValues()

import "influxdata/influxdb/schema"

schema.measurementTagValues(
    bucket: "bucket-name",
    measurement: "measurement-name",
    tag: "_field",
)

List unique tag values

List all unique tag values for a specific tag in a specified bucket. The example below lists all unique values of the host tag.

Flux package: InfluxDB schema
Flux functions: schema.tagValues()

import "influxdata/influxdb/schema"

schema.tagValues(bucket: "bucket-name", tag: "host")

List Docker containers

List all Docker containers when using the Docker Telegraf plugin.

Telegraf plugin: Docker
Flux package: InfluxDB schema
Flux functions: schema.tagValues()

import "influxdata/influxdb/schema"

schema.tagValues(bucket: "bucket-name", tag: "container_name")

List Kubernetes pods

List all Kubernetes pods when using the Kubernetes Telegraf plugin.

Telegraf plugin: Kubernetes
Flux package: InfluxDB schema
Flux functions: schema.measurementTagValues()

import "influxdata/influxdb/schema"

schema.measurementTagValues(
    bucket: "bucket-name",
    measurement: "kubernetes_pod_container",
    tag: "pod_name",
)

List Kubernetes nodes

List all Kubernetes nodes when using the Kubernetes Telegraf plugin.

Telegraf plugin: Kubernetes
Flux package: InfluxDB schema
Flux functions: schema.measurementTagValues()

import "influxdata/influxdb/schema"

schema.measurementTagValues(
    bucket: "bucket-name",
    measurement: "kubernetes_node",
    tag: "node_name",
)