How to display total alerts triggered using mysql database?

  • What Grafana version and what operating system are you using?
    Latest Grafana version and Windows 10

  • What are you trying to achieve?
    I want to display the total number of alerts that are triggered in a single stat panel. I am using MySQL database.

  • How are you trying to achieve it?
    I have no idea

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

I urgently need this.

Hi @mayurvidhwani7387

You need to explore the Alerting HTTP API

Try curl http://your-grafana-here/api/alerts | jq

Please remember to mark topics as answered if someone answers your query :+1:

1 Like