I am creating a dashboard and try to generate an sample email alert when 3 is greater than 1. My dashboard got updated to grafana successfully but alerts are not generating. If I create alert from Grafana UI, after setting alert rule, alert got generated. Please review the code to identify any missing bit, please also suggest the complete process to receive an email alert via jsonnet code. Please note, my smtp setting are okay.
local grafana = import ‘grafonnet/grafana.libsonnet’;
local dashboard = grafana.dashboard;
local row = grafana.row;
local template = grafana.template;
local graphPanel = grafana.graphPanel;
local singlestat = grafana.singlestat;
local prometheus = grafana.prometheus;
local alertCondition = grafana.alertCondition;
local emailChannel = grafana.notificationChannel.email(
‘email’,
to=[‘tayyabaslam820@gmail.com’],
address=‘smtp.example.com:587’,
from=‘grafana@example.com’,
user=‘tayyabaslam820@gmail.com’,
password=‘vzbcnjyzlqfugjcd’
);
grafana.dashboard.new(
‘MSSQL dashboard email’,
refresh=‘1m’,
editable=true,
time_from=‘now-12h’
)
.addTemplate(
grafana.template.datasource(
‘server’,
‘prometheus’,
‘Prometheus’,
label=‘Server’,
),
)
.addTemplate(
template.new(
‘Job’,
‘$server’,
‘label_values(mssql_instance_local_time, job)’,
label=‘Job’,
refresh=‘time’,
),
)
.addTemplate(
template.new(
‘database’,
‘$server’,
‘label_values(mssql_database_state,database)’,
label=‘database’,
refresh=‘time’,
),
)
.addRow(
row.new(
title=‘Server resource overview’,
height=‘125px’,
)
.addPanel(
graphPanel.new(
‘Server Local time’,
)
.addTarget(
prometheus.target(
‘1+2’,
datasource=‘$server’,
),
).addAlert(
name=‘test’,
executionErrorState=‘alerting’,
forDuration=‘5m’,
frequency=‘60s’,
handler=1,
message=‘’,
noDataState=‘no_data’,
notifications=[
{
id:1,
type:‘email’,
name:‘abc@gmail.com’,
subject:‘Alert High CPU usage’,
message:‘CPU usage is above 90%’,
}
],
alertRuleTags={},
).addCondition(
alertCondition.new(
evaluatorParams=[1],
evaluatorType=‘gt’,
operatorType=‘and’,
queryRefId=‘A’,
queryTimeEnd=‘now’,
queryTimeStart=‘24h’,
# reducerParams=,
# reducerType=‘avg’,
)
)
)
)