Hello,
We are trying to create a reporting dashboard so we want that the alerts which are triggered in last 24 hours to be inserted into SQL table.
Is is possible ? if yes, then how can we achieve this.
Thanks in advance.
This could be easily done using Node-RED. Set up a node to receive the Grafana alert emails, count them over the last 24 hours at a certain hour of each day, and send update query to MSSQL.