Threshold variables

Question

Is there a variable, or combination of variables, I can use that shows the Threshold for a APM component alarm?  I need to show the complete threshold in the Email I send for the alarm.  For example I am doing some Performance counters and I set the threshold to alarm if the counter is "less than or equal to 99".  I tried using ${Threshold-Statistic-Warning} but it only shows the threshold as 99. I want to show the complete "less than or equal to 99"

qle · Answer

The following custom SQL query should provide the description name of the threshold operator

${SQL:select case thresholdoperator when '4' then 'less than' when '3' then 'less than or equal to' when '2' then 'equal to' when '1' then 'greater than or equal to' when '0' then 'greater than' end from APM_Threshold where ID=${ApplicationID}}

Let me know how this works out for you.

FormerMember · Answer

Does anyone know how to pull this?  Maybe a SQL query?  I'd love to be able to include these in emails.

Thanks,

Mike