NWConnectionMonitorTestResult 數據表的查詢

如需在 Azure 入口網站 使用這些查詢的詳細資訊，請參閱Log Analytics教學課程。 如需 REST API，請參閱 查詢。

失敗的測試

取得每個資源失敗的不同來源、目的地、測試群組和測試組態。

NWConnectionMonitorTestResult 
| where TimeGenerated > ago(24h) 
| where TestResult == "Fail"
| distinct _ResourceId, SourceName, DestinationName, TestGroupName, TestConfigurationName

測試效能

取得資源指定來源與目的地之間的遺失百分比和平均延遲。

// For specific results, insert values in the let statements and uncomment the where filters within the query
// let connectionMonitorResourceId = "<Connection Monitor Resource Id>";
// let sourceName = "<Source Name>";
// let destinationName = "<Destination Name>";
// let testGroupName = "<Test Group Name>";
// let testConfigurationName = "<Test Configuration Name>";
NWConnectionMonitorTestResult 
| where TimeGenerated > ago(24h) 
// | where ConnectionMonitorResourceId has connectionMonitorResourceId
// | where SourceName has sourceName
// | where DestinationName has destinationName
// | where TestGroupName has testGroupName
// | where TestConfigurationName has testConfigurationName
| extend LossPercent = ChecksFailed * 100 / ChecksTotal
| project TimeGenerated, ConnectionMonitorResourceId, TestResult, AvgRoundTripTimeMs, LossPercent, SourceName, SourceAddress, DestinationName, DestinationAddress
| order by TimeGenerated desc;