Hey all,
trying to send email alerts w/ meaningful info for template critical thresholds met.
Same alert for different components...translates properly
Threshold Settings (if set):
Name: Response
PollFrequency: 60
Critical Threshold: 3500
3 out of 3 polls.
This one didn't...NOTICE the internal '{' and '}' got replaced w/ @ signs
Threshold Settings (if set):
Name: ${SQL:select (isNULL(ThresholdName,'')) from APM_Threshold where ID=$@ComponentID@}
PollFrequency: ${SQL:select (isnull(apps.Value,ats.Value)) from APM_Component c WITH (NOLOCK) left join APM_ComponentTemplate ct WITH (NOLOCK) on c.templateid=ct.id left join APM_ApplicationTemplateSetting ats WITH (NOLOCK) on ct.ApplicationTemplateID=ats.ApplicationTemplateID left join APM_ApplicationSetting apps WITH (NOLOC K) on c.ApplicationID=apps.ApplicationID where c.ID=$@ComponentID@ and ats.[Key] like '%[_][_]Frequency%' and (apps.[Key] like '%[_][_]Frequency%' or apps.[Key] is null)}
Critical Threshold: ${SQL:select (isNULL(Critical,'')) from APM_Threshold where ID=$@ComponentID@}
${SQL:select (isNULL(criticalPolls,'')) from APM_Threshold where ID=$@ComponentID@}
out of ${SQL:select (isNULL(criticalPollsInterval,'')) from APM_Threshold where ID=$@ComponentID@} polls.
anyone have any thoughts?