After re-reading what you said about “querying the right table” I updated the alert rule which I believe now I should be able to use this in the alert template?
