Connection monitor schemas
Connection monitor stores the data it collects in a Log Analytics workspace. There are two types of logs or data ingested into Log Analytics from connection monitor:
- The test data (
NWConnectionMonitorTestResultquery), which is updated based on the monitoring frequency of a particular test group. - The path data (
NWConnectionMonitorPathResultquery), which is updated when there's a significant change in loss percentage or round-trip time.
For some time durations, test data might keep getting updated while path data isn't frequently updated because both are independent.
In this article, you learn about the available fields in the connection monitor tests data and path data schemas.
Connection monitor tests schema
The following table lists the fields in the connection monitor tests data schema and what they signify:
| Field | Description |
|---|---|
| TimeGenerated | The timestamp (UTC) of when the log was generated. |
| RecordId | The record ID for unique identification of the test result record. |
| ConnectionMonitorResourceId | The connection monitor resource ID of the test. |
| TestGroupName | The test group name to which the test belongs. |
| TestConfigurationName | The test configuration name to which the test belongs. |
| SourceType | The type of the source machine configured for the test. |
| SourceResourceId | The resource ID of the source machine. |
| SourceAddress | The address of the source configured for the test. |
| SourceSubnet | The subnet of the source. |
| SourceIP | The IP address of the source. |
| SourceName | The source endpoint name. |
| SourceAgentId | The source agent ID. |
| DestinationPort | The destination port configured for the test. |
| DestinationType | The type of the destination machine configured for the test. |
| DestinationResourceId | The resource ID of the destination machine. |
| DestinationAddress | The address of the destination configured for the test. |
| DestinationSubnet | If applicable, the subnet of the destination. |
| DestinationIP | The IP address of the destination. |
| DestinationName | The destination endpoint name. |
| DestinationAgentId | The destination agent ID. |
| Protocol | The protocol of the test. |
| ChecksTotal | The total number of checks done under the test. |
| ChecksFailed | The total number of checks failed under the test. |
| TestResult | The result of the test. |
| TestResultCriterion | The result criterion of the test. |
| ChecksFailedPercentThreshold | The checks failed percent threshold set for the test. |
| RoundTripTimeMsThreshold | The round-trip threshold (in milliseconds) set for the test. |
| MinRoundTripTimeMs | The minimum round-trip time (in milliseconds) for the test. |
| MaxRoundTripTimeMs | The maximum round-trip time for the test. |
| AvgRoundTripTimeMs | The average round-trip time for the test. |
| JitterMs | The mean deviation round-trip time for the test. |
| AdditionalData | Other data for the test. |
Connection monitor path schema
The following table lists the fields in the connection monitor path data schema and what they signify:
| Field | Description |
|---|---|
| TimeGenerated | The timestamp (UTC) of when the log was generated. |
| RecordId | The record ID for unique identification of the test result record. |
| TopologyId | The topology ID of the path record. |
| ConnectionMonitorResourceId | The connection monitor resource ID of the test. |
| TestGroupName | The test group name to which the test belongs. |
| TestConfigurationName | The test configuration name to which the test belongs. |
| SourceType | The type of the source machine configured for the test. |
| SourceResourceId | The resource ID of the source machine. |
| SourceAddress | The address of the source configured for the test. |
| SourceSubnet | The subnet of the source. |
| SourceIP | The IP address of the source. |
| SourceName | The source endpoint name. |
| SourceAgentId | The source agent ID. |
| DestinationPort | The destination port configured for the test. |
| DestinationType | The type of the destination machine configured for the test. |
| DestinationResourceId | The resource ID of the destination machine. |
| DestinationAddress | The address of the destination configured for the test. |
| DestinationSubnet | If applicable, the subnet of the destination. |
| DestinationIP | The IP address of the destination. |
| DestinationName | The destination endpoint name. |
| DestinationAgentId | The destination agent ID. |
| Protocol | The protocol of the test. |
| ChecksTotal | The total number of checks done under the test. |
| ChecksFailed | The total number of checks failed under the test. |
| PathTestResult | The result of the test. |
| PathResultCriterion | The result criterion of the test. |
| ChecksFailedPercentThreshold | The checks failed percent threshold set for the test. |
| RoundTripTimeMsThreshold | The round-trip threshold (in milliseconds) set for the test. |
| MinRoundTripTimeMs | The minimum round-trip time (in milliseconds) for the test. |
| MaxRoundTripTimeMs | The maximum round-trip time for the test. |
| AvgRoundTripTimeMs | The average round-trip time for the test. |
| JitterMs | The mean deviation round-trip time for the test. |
| HopAddresses | The hop addresses identified for the test. |
| HopTypes | The hop types identified for the test. |
| HopLinkTypes | The hop link types identified for the test. |
| HopResourceIds | The hop resource IDs identified for the test. |
| Issues | The issues identified for the test. |
| Hops | The hops identified for the test. |
| AdditionalData | Other data for the test. |