Kusto查询问题 [英] Issue with Kusto query

查看:137
本文介绍了Kusto查询问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我对KQL查询非常陌生。

I am very much new to KQL query.

我想写一个查询来获取Run Id 11189来自Response>结果列。

I want to write a query to fetch Run Id 11189 from Response > result column.

您能否告诉我如何获取如下详细信息?

Can you please let me know how can I get the details like below?

sss

Thankx& amp;问候,Vipin jha MCP

Thankx & regards, Vipin jha MCP

推荐答案

您好Vipin jha,您可以使用以下查询获取run_id为11189的列。



Hi Vipin jha, You may use below query to get columns whichever has run_id as 11189.

xxxxxxx | where Response contains "run_id\":11189"






$
(或)b





(or)

xxxxxxx | where Response contains "run_id\\":11189" 




$


其中xxxxxxx被认为是你的类型或表名。



如果你想获取run_id并进一步用于其他操作,那么使用extend,project, mvexpand等运营商。



所有上述运营商都在解释
这里




希望这有帮助!!




where xxxxxxx is considered as your type or table name.

If you want to fetch the run_id and use it further for some other operation then use extend, project, mvexpand, etc. operators.

All the above mentioned operators are explained here

Hope this helps!!


这篇关于Kusto查询问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆