Grafana v8.1.2 Alerting - Help

Hi all,
I have updated from Grafana 7.4 to v8.1.2, all my alerts have been brought across but have lost ALL labels and metric information from the email it triggers.

After reading up about it it seems that the metrics etc cannot be used by the “Classic” queries.

So…

I have attempted to update the queries following the guides as best I can but the problem I have is:

Alerts seem to be stuck at pending state and just resetting to pending

Example:




For some reason the above just seems to loop on pending can someone explain why?

Any help with this would be amazing as I have 300+ alerts to resolve :frowning:
Thanks in advance