Hello, I am trying to add something like SLA breached column if the response time if higher than what is in the threshold.
SELECT
VoIPOperationCurrentStats.OperationName AS Operation_Name, VoIPOperationCurrentStats.Description AS Description, VoIPOperationCurrentStats.RoundTripTime AS Round_Trip_Time,
CASE
WHEN AVG(VoIPOperationCurrentStats.RoundTripTime) < VoIPOperationCurrentStats.RoundTripTime THEN 'PASSED'
ELSE 'SLA BREACHED'
END AS SLA,
CASE
WHEN AVG(VoIPOperationCurrentStats.RoundTripTime) > VoIPOperationCurrentStats.RoundTripTime AS Round_Trip_Time THEN 'Up.gif'
ELSE 'Down.gif'
END AS SLA_Status
FROM
VoIPOperationCurrentStats
WHERE
(
(VoIPOperationCurrentStats.OperationName LIKE '%BO%')
)
GROUP BY VoIPOperationCurrentStats.RoundTripTime, VoIPOperationCurrentStats.OperationName
ORDER BY 1 ASC
