Questions tagged [grafana-variable]
245 questions
0
votes
1 answer
Show time series for all hosts in grafana
I am building some grafana monitors to watch many hosts. As an example, one plots free disk space, and I see a separate plot for each host. The main interesting thing is any hosts that show periodic or secular drops.
I have a variable and group by…
jma
- 3,580
- 6
- 40
- 60
0
votes
1 answer
Grafana Dashboard setup for Prometheus Federation
I am using prometheus federation to scrape metrics from multiple k8s cluster. It works ok and I would like to create some dashboard on grafana which I'd like to filter dashboards by tenant(cluster).. I am trying to use variables but the things that…
semural
- 3,583
- 8
- 37
- 67
0
votes
1 answer
Grafana 6.6+ admin role assignment for keycloak user
By default keycloak user is getting viewer premission when we use login with keycloak option in Grafana. Is it possible to get the admin premission for keycloak user?
0
votes
1 answer
grafana variables dynamically changing mysql
I am trying to add dropdowns (grafana variables) in my dashboard that changes dynamically. This what I tried
Created variable named Domain
Query : select fields_Domain from launcher_dropdown;
Output: "ABC ESG"
Created variable named Project(…
curiousguy
- 3,212
- 8
- 39
- 71
0
votes
1 answer
How to create a Elastic Search dashboard in Grafana with variable (dropdown to filter data) independent of Time Range Filter
I have created a Variable in Grafana 6.6 to provide filter dropdown option to user. I am using Elastic Search datasource. But the dropdown lists are coming filtered by time range .How we can make it independent of time range , in other words I don’t…
curiousguy
- 3,212
- 8
- 39
- 71
0
votes
1 answer
Grafana singlestat value color
I need to change value color to black in singlestat pannel, and backgrund color by mertic.
How to change the color of the value separately from the background color?
Example:
Background color green - value color black
Background color red - value…
EzMachine
- 1
- 2
0
votes
2 answers
Grafana: using instance label in title field of stats panel
i’m searching for a possibility to show the instance label (node_boot_time_seconds{instance="***.local:9100"}) in the title field of a stats panel. There is a hover message
Template Variables:
${__series.name}
${__field.name}
$__cell_{N} /…
rosaLux161
- 33
- 8
0
votes
1 answer
Grafana query to fetch a particular value from JSON
If I use jvm_memory_max_bytes it is automatically feeding the data, but I need to split up the required one to display. How can I fetch an ID with a particular value to add in a Grafana query?
jvm_memory_max_bytes{area="heap", id="CMS Old Gen",…
user3428736
- 864
- 2
- 13
- 33
0
votes
1 answer
Why do Grafana ElasticSearch queries work when hard coded, but fail when using Grafana variable value substitution? and how to fix it?
ElasticSearch query works when hard coded, but fails when using Grafana variable value substitution:
Query: +nginx.access.upstream.response: [*, 1**, 2**, 3**, 4**, 5**, 500]
Each of these queries work when you hard code those values in the…
neoakris
- 4,217
- 1
- 30
- 32
0
votes
1 answer
Save Grafana alert to SQL Database
We are using Grafana to monitor security events occurrng by our clients. We have teams that deal with and resolve these events and problems that occur.
We want to have the Grafana alerts automatically turned into service tickets by having the alerts…
Dov Miller
- 1,958
- 5
- 34
- 46
0
votes
1 answer
Grafana: How to check in a query if a single variable is selected or more?
I have a dashboard where I have a variable X for which one or more values can be selected. The data source is postgresql. I have a panel where I make a query to show some trends using X. Up till this point everything is working.
Now, I need to check…
MozenRath
- 9,652
- 13
- 61
- 104
0
votes
1 answer
grafana+prometheus: repeat graf
I'm using stack grafana:6.0.1 + prometheus:v2.7.2 + grafana:6.0.1 to monitor my hosts.
I have created a dashboard in Grafana to visualize metrics per monitored host and I want to dynamically display disk usage of each mount point in separate graf.…
Mr.B
- 3
- 4
0
votes
1 answer
how to add new sublist to Grafana
I am new to Grafana. I have a dashboards like below and I want to add one more list call appmetrics under the kafka metrics. I do not know how to add it. Thank you for the help.
enter image description here
qing zhang
- 125
- 1
- 4
- 13
0
votes
2 answers
Grafana - How to create sql query part variable/macro for Mysql datasource
I have following query in Grafana which is backed by MySql DataSource.
SELECT
$__timeGroupAlias(ts,$__interval),
sum(total) AS "total"
FROM hp
WHERE
$__timeFilter(ts)
AND customer_type IN ($CustomerType) AND age IN ($age) AND gender IN…
dnsh
- 3,516
- 2
- 22
- 47
0
votes
1 answer
breaking field value on hypen
I have following sample docs in Elasticsearch
[
{
"_index": "beatbox-2018.11.19",
"_source": {
"connection": "10",
"user": "op-dashboard",
"key": "monolith_connection_sniffer"
}
},
{
"_index":…
Shahriar
- 13,460
- 8
- 78
- 95