I have installed the grafana 9 on ubunt 20.04 and trying to setup alerting but i don't know how to send the common_name result from below grafana query in the alert notification message so please check and suggest what i have to do to add common_name in the notification. ??
I think may be i need to use templating in this case ?? if yes then please share the sample template which can help because i am not much familiar with golang.
SELECT (expiry / 60 / 60 / 24) as "expiry" FROM "x509_cert" WHERE $timeFilter GROUP BY common_name,san
Thanks