AppInsights查询具体时间范围

Question

我想在美国东部时间每天早上7点到晚上10点之间查询下面的appinsights日志。任何与此相关的帮助都将不胜感激

dependencies
|where success == "False"
|where type == "Azure queue"
|where operation_Name == "XXXXTrigger"

Answer 1

您可以使用以下代码进行查询。你可以像下面两张图片一样改变TimeZone。或者，您可以使用new()-5h来转换EST时间。

方法1:更改TimeZone

dependencies
|where success == "False"
|where type == "Azure queue"
|where operation_Name == "XXXXTrigger"
|where timestamp between(todatetime(strcat(format_datetime(now(),'yyyy-MM-dd')," ",'07:00:00')) .. todatetime(strcat(format_datetime(now(),'yyyy-MM-dd')," ",'22:00:00')))

​

​

​

​

方法2：new()-5h

dependencies
|where success == "False"
|where type == "Azure queue"
|where operation_Name == "XXXXTrigger"
|where timestamp between(todatetime(strcat(format_datetime(now()-5h,'yyyy-MM-dd')," ",'07:00:00')) .. todatetime(strcat(format_datetime(now()-5h,'yyyy-MM-dd')," ",'22:00:00')))