azure-application-insights - Application Insights，将时差转换为毫秒

Question

如何在 Azure Application Insights 中将时差转换为毫秒

let startTime = todatetime('2017-05-15T17:02:23.7148691Z');
let endTime = todatetime('2017-05-15T17:02:25.5430172Z');
let timeDifference = endTime-startTime;
requests
| project timeDifference
| limit 1

以上查询输出

00:00:01.8281481

我想以毫秒为单位显示

例如:1828

Answer 1

您可以将您的时间跨度除以另一个时间跨度。因此，要获取毫秒数，您可以执行以下操作:

let startTime = todatetime('2017-05-15T17:02:23.7148691Z');
let endTime = todatetime('2017-05-15T17:02:25.5430172Z');
let timeDifference = endTime-startTime;
// get total milliseconds 
requests
| extend timeDifferenceMilliseconds = timeDifference / time(1ms)
| project timeDifferenceMilliseconds
| limit 1

可以在此处找到有关日期和时间表达式的更多信息:https://learn.microsoft.com/en-us/azure/application-insights/app-insights-analytics-reference#date-and-time-expressions