在Azure中的日志分析中,我为VM心跳选择了一个预定义的查询,我在编辑器中运行该查询,但当我去创建警报时,我一直得到"查询未返回TimeGenerated列。请编辑查询并包含TimeGenerated列">
这很奇怪,因为它在编辑器中工作,而且它是我从MS使用的预定义查询?这里有什么问题?
// Not reporting VMs
// VMs that have not reported a heartbeat in the last 5 minutes.
// To create an alert for this query, click '+ New alert rule'
Heartbeat
| where TimeGenerated > ago(24h)
| summarize LastCall = max(TimeGenerated) by Computer, _ResourceId
| where LastCall < ago(5m)
将LastCall重命名为TimeGenerated,您应该可以使用:
Heartbeat
| where TimeGenerated > ago(24h)
| summarize TimeGenerated = max(TimeGenerated) by Computer, _ResourceId
| where TimeGenerated < ago(5m)