Grafana Alerts to Database

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.