title | description | ms.topic | ms.service | ms.author | author | ms.date |
---|---|---|---|---|---|---|
Example log table queries for NWConnectionMonitorTestResult |
Example queries for NWConnectionMonitorTestResult log table |
reference |
azure-monitor |
edbaynash |
EdB-MSFT |
02/18/2024 |
Gets failed distinct source, destination, test group and test configuration for each resource.
NWConnectionMonitorTestResult
| where TimeGenerated > ago(24h)
| where TestResult == "Fail"
| distinct _ResourceId, SourceName, DestinationName, TestGroupName, TestConfigurationName
Gets loss percentage and average latency between given source and destination of a resource.
// 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;