Azure Log Analytics 查询属性是否存在

Question

我试图检查我的 customDimensions 对象是否具有属性，然后仅计算将该属性设置为某项的查询。它正在对 customDimensions 对象中没有 SupportedLanguage 属性的查询进行计数。

这是我当前的查询:

customEvents
| where timestamp > ago(7d)
| summarize COUNT=count(customDimensions.SupportedLanguage) by lang=tostring(customDimensions.SupportedLanguage)
| render piechart

我尝试执行以下操作，但没有成功:

customEvents
| where timestamp > ago(7d)
| where customDimensions.SupportedLanguage
| summarize COUNT=count(customDimensions.SupportedLanguage) by lang=tostring(customDimensions.SupportedLanguage)
| render piechart 

Answer 1

您可以利用isnotempty()用于此目的的函数:

customEvents
| where timestamp > ago(7d)
| where isnotempty(customDimensions.SupportedLanguage)