azure - 如何在 Azure Application Insights 中获取 Web 测试的可用性 SLA 报告

Question

我们正在使用 Application Insight，并添加了一些 Web 测试来监控我们的网站。 Web 测试每 5 分钟从三个位置运行一次，并且所有三个位置都需要在 5 分钟内失败才能发出警报。

Application Insights 中是否有一些报告可供我们用来向客户报告上个月的可用性？我们需要至少一位小数的可用性百分比。

更新:根据@ZakiMa 的回答，我最终得到以下查询:

let lastmonthstart = startofmonth(now(), -1);
let lastmonthend = endofmonth(lastmonthstart);
availabilityResults
| where timestamp between(lastmonthstart .. lastmonthend)
| summarize failurecount=countif(success == 0), successcount=countif(success == 1) by name, bin(timestamp, 5m)
| project failure = iff(failurecount > 0 and successcount == 0, 1, 0), name, bin(timestamp, 5m)
| summarize totalFailures = sum(failure), totalTests = count(failure) by name
| project ["Name"] = name, ["SLA"] = todouble(totalTests - totalFailures) / todouble(totalTests) * 100
| order by ["SLA"]

Answer 1

您可以使用 Application Insights Analytics 计算 SLA。单击概述页面上的“分析”菜单项并使用以下查询:

availabilityResults
| where timestamp > ago(30d)
| summarize _successCount=todouble(countif(success == 1)),
            _errorCount=todouble(countif(success == 0)),
            _totalCount=todouble(count()) by name
| project
          ["Name"] = name,
          ["SLA"] = _successCount / _totalCount * 100
| order by ["SLA"]

你应该得到这样的东西:

然后您可以将其固定到仪表板(右上角有一个图钉图标):

这只是一个示例 - 在这里您可以找到完整的分析查询语言引用 - 它非常强大:https://learn.microsoft.com/en-us/azure/application-insights/app-insights-analytics-reference 。您可以调整您对 SLA 的定义。

编辑:这是一个更接近您的问题的查询示例

availabilityResults
| where timestamp > ago(30d)
// check whether location failed within 5m bin
| summarize _failure=iff(countif(success == 0)>0, 1, 0) by name, location, bin(timestamp, 5m)
// check whether all locations failed within 5m bin
| summarize _failureAll=iff(sum(_failure)>=3, 1, 0) by name, bin(timestamp, 5m)
// count all failed 5 minute bins and total number of bins
| summarize _failuresCount=sum(_failureAll), _totalCount=count() by name
| project ["Name"] = name,
          ["SLA"] = todouble(_totalCount - _failuresCount) / todouble(_totalCount) * 100
| order by ["SLA"]