I have several MAPI user expereince monitors set up and want to send an email alert if it breaks the threshold. I want to include in the email the measured response time.
Has any one done this and if so how?
Solved my own question......
Current Response Time is: ${SQL:select top 1 APM_ResponseTime.responsetime from (Nodes INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID = APM_AlertsAndReportsData.NodeId)) INNER JOIN APM_ResponseTime ON (APM_AlertsAndReportsData.ComponentId = APM_ResponseTime.ComponentID) where APM_AlertsAndReportsData.ApplicationName = '${Name}'} ms.
