Dynamic Variables

Grafana
, ,
1

Hi Team ,

Being new to influxdb(v2.7.11) I need your assistance for following

  1. How to enter to Influxdb Cli to get some basic understanding of queries.

admin01@Ubuntu:~$ grafana-server --version
Version 11.4.0
admin01@Ubuntu:~$ influxd - version
InfluxDB v2.7.11 (git: fbf5d4ab5e) build_date: 2024-12-02T17:48:15Z
admin01@Ubuntu:~$ influx v1
influx
NAME:
influx - Influx Client
USAGE:
influx [command]

COMMANDS:
version Print the influx CLI version
write Write points to InfluxDB
bucket Bucket management commands
completion Generates completion scripts
query Execute a Flux query
config Config management commands
org, organization Organization management commands
delete Delete points from InfluxDB
user User management commands
task Task management commands
telegrafs List Telegraf configuration(s). Subcommands manage Telegraf configurations.
dashboards List Dashboard(s).
export Export existing resources as a template
secret Secret management commands
v1 InfluxDB v1 management commands
auth, authorization Authorization management commands
apply Apply a template to manage resources
stacks List stack(s) and associated templates. Subcommands manage stacks.
template Summarize the provided template
bucket-schema Bucket schema management commands
ping Check the InfluxDB /health endpoint
setup Setup instance with initial user, org, bucket
backup Backup database
restore Restores a backup directory to InfluxDB
remote Remote connection management commands
replication Replication stream management commands
server-config Display server config
help, h Shows a list of commands or help for one command

GLOBAL OPTIONS:
–help, -h show help

Secondly I am using multiple routers for cisco telemetery and I can see data on Infludb/grafana graphs. Now I want to use Dynamic variables to display multiple routers hostname . How I can do it , i have tried follwoing but it is now showing anything .
SHOW TAG VALUES WITH KEY = “host”
SHOW TAG VALUES WITH KEY = “hostname”

thanks for your feedback
Regards

2

Hi @uniquewaheed

It looks like you have installed Influx v2.7.11 with Flux, but in the second part of your post, you are using InfluxQL syntax. These are two different languages introduced by InfluxData.

More here: A comparison of InfluxQL, SQL, and Flux query languages for Grafana dashboards | Grafana Labs

3

Thanks grant2 for your feedback.

Can I install flux and sql simaltnasouly or not if yes how can I install them and can we configure them with some priority on influxdb.
thanks for your feedback.

4

No. Like it says in the linked blog post:

Grafana users who store data in InfluxDB need to choose from three possible query languages: InfluxQL, SQL or Flux

5

Hi ,

I believe we create two datastore with Influxdb with two different query lanaguages. Right?.

6

Given everything you have shared thus far, I believe you only need one InfluxDB datasource and one query language.

7

Yes, so it means that I need separte instance of Infludb for both QLs. right?

8

As the linked article says “Before getting started, however, Grafana users who store data in InfluxDB need to choose from three possible query languages.”

Read through the article and go with the one that makes the most sense for your situation and comfort level.