所以,我有个问题要问
requests
| where customDimensions has'Scope' and customDimensions['Scope'] != 'Unauthenticated' and cloud_RoleName == 'cloud1'
| project x = tostring(customDimensions['x'], y = tostring(customDimensions['y'] ...
我想把我的customDimensions
个值分成3个JSON.
| project json1 = json1, json2 = json2, json3 = json3
但我无法对customDimensions进行分组/拆分我try 了动态数据表,但它们不将变量作为输入
上面的语句给出的错误是it should end with '}'
,显然我的语法是正确的.我觉得它无法访问dynamic或datatable中的customDimensions变量
有人能给我介绍一下吗..
我希望输出为
| json1 | json2 | json3 |
|{...} | {...} | {...} |
所有3个json都将从同一个表的customDimensions或其他列创建;
关于customDimensions https://camerondwyer.com/2020/05/26/how-to-use-application-insights-custom-properties-in-azure-monitor-log-kusto-queries/
假设customDimensions中有
customDimensions = {x:X, y:Y, a:A, ...}
json1 should have {x, y z}
json2 should have {r, t, p,}
json3 should have {w, m, n}