Templating last value of metric into alert message

[coderuslan]

Hello Everyone!

I have a following query in my alert:

100 -
(
  avg(node_memory_MemAvailable_bytes{job="node-exporter", instance="211.111.11.111:9111"}) /
  avg(node_memory_MemTotal_bytes{job="node-exporter", instance="211.111.11.111:9111"})
* 100
)

And my query in alert and condition looks like this(look at image):

I want to have a following alert text: Instance 211.111.11.111:9111 has 60 point of Memory Usage when Threshold is 50. Investigate the problem
So I want to template instance ip and last value of Memory Usage right now,
I have tried to use {{ $values.B }} and it resulted in .
Only success I had when using {{ $value }} and as output I got this information:

Instance 211.111.11.111:9111 has [ var='B0' metric='100 -
(
 avg(node_memory_MemAvailable_bytes{job="node-exporter", instance="211.111.11.111:9111"}) /
 avg(node_memory_MemTotal_bytes{job="node-exporter", instance="211.111.11.111:9111"})
* 100
)
' labels={} value=41.96771814524034 ] % of Memory Usage. Investigate the problem

And out of this I need to get value=41.96771814524034

Any help is appreciated. Thanks!

[ldrascic]

Hi @coderuslan,
Try this:

{{ $values.B.Value }}

If you want to print only 1 decimal:

{{ printf "%.1f" $values.B.Value }}

Additionally, check links below:

Grafana v8.1.2 (103f8fa094) Alert Always Pending

Hi @prabhat8ranjan, He wanted to say that you should never put metrics into labels (check label Value in his last picture) because they change at every alert evaluation interval (based on query). Every time metric in label changes grafana creates new alert and starts to monitor it. At next evaluation Value label will probably have different metric (e.g. Value=85.12345 ) value (which would start new alert in pending if threshold is met) and then previous alert (with let’s say Value=83.6788) wou…

How To Use Alert Message Templates in Grafana

Hi @rodrigoparavano, If you want to get label value from query then you can do with: {{ $values.<queryname>.Labels.<tag> }} For example: On server {{ $values.B.Labels.host }} port {{ $values.B.Labels.port }} is closed (not listening). would print: On server monitoringserver port 8282 is closed (not listening).

Alert configuration and output

<a class="lightbox" href="https://global.discourse-cdn.com/grafana/original/3X/7/0/706158fc7637855f8a674f514e16f35262cd9f79.png"…

Best regards,
ldrascic

[coderuslan]

Hi @ldrascic ldrascic I have tried using
{{ $values.B.Value }}
But it has resulted in < no values > message being show, thank you for additional links I will also look into them.

Kind Regards

[ldrascic]

I guess it makes difference if you are using Reduce (like in my example) or Classic condition (your example). Try solution that was proposed in next answer:

{{ $values.B0.Value }}

How To Use Alert Message Templates in Grafana

Hi! It looks like you are using Classic Conditions, which because can have multiple conditions (i.e. an average, a min, and a max all together) you need to append the index of the condition too. For example, in your screenshot you would use: {{ $values.D0.Labels.name }} to get the name label for query A.

Also, the printf "%.1f" part does not work with classic condition .

[georgerobinson]

Hi! If it helps the documentation for this can be found here Templating labels and annotations | Grafana documentation, including for Classic Conditions