Azure 应用程序洞察 | KQL|获取异常详细信息

Question

我们正在使用 Azure 应用程序 Insights 进行错误日志记录。我是 KQL 新手，并尝试按以下格式从内置的“customDimensions”列中获取自定义属性，

“customDimensions”列中的数据

{
  "File Name":"Sample File 1",
  "Correlation ID":"e33a8d45-0566-4bf2-94f8-54a6fec29bff",
  "Error List":"[
      {
        "Function Name":"Sample Function 1",
        "Code":"#231256#"
      },
      {
        "Function Name":"Sample-Function-2",
        "Code":"#231258#"
      },
   ]"
}

预期输出

<表类=“s-表”><标题>文件名相关 ID函数名称代码 <正文>示例文件1e33a8d45-0566-4bf2-94f8-54a6fec29bff示例函数 1#231256#示例文件1e33a8d45-0566-4bf2-94f8-54a6fec29bff示例函数2#231258#

如何使用 KQL 实现上述输出？

谢谢。

更新:添加示例数据表

datatable(ErrorDetails:dynamic)
[
    dynamic({
        "File Name":"Sample File 1",
        "Correlation ID":"e33a8d45-0566-4bf2-94f8-54a6fec29bff",
        "Error List": [{
                "Function Name":"Sample Function 1",
                "Code":"#231256#"
            },
            {
                "Function Name":"Sample-Function-2",
                "Code":"#231258#"
            }
        ]
    })
]

Answer 1

mv-expand运算符

datatable(ErrorDetails:dynamic)
[
    dynamic({
        "File Name":"Sample File 1",
        "Correlation ID":"e33a8d45-0566-4bf2-94f8-54a6fec29bff",
        "Error List": [{
                "Function Name":"Sample Function 1",
                "Code":"#231256#"
            },
            {
                "Function Name":"Sample-Function-2",
                "Code":"#231258#"
            }
        ]
    })
]
| mv-expand EL = ErrorDetails.["Error List"]
| project ["File Name"] = ErrorDetails["File Name"], ["Correlation ID"] = ErrorDetails["Correlation ID"], ["Function Name"] = EL["Function Name"], ["Code"] = EL["Code"]

<表类=“s-表”><标题>文件名相关 ID函数名称代码 <正文>示例文件1e33a8d45-0566-4bf2-94f8-54a6fec29bff示例函数 1#231256#示例文件1e33a8d45-0566-4bf2-94f8-54a6fec29bff示例函数2#231258#

Fiddle