we need to integrate the metrics from AppInsight for SQL application template, such as Repl. Trans Rate, in the alert email. The variable is not visible in the trigger action. Would anyone kindly help me?
I don't believe it is there, but I could be wrong, there was a feature request for the same that was raised 4 years back - hope this helps
Add alerting variables for AppInsight SQL components - Feature Requests - Server & Application Monitor (SAM) - THWACK