[Feature]: Add VNET connectivity status output for Get-AzVirtualHubVnetConnection

[feliasson]

Description of the new feature

Sample output from Get-AzVirtualHubVnetConnection

Name                   : <obfuscated>
Id                     : /subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualHubs/<obfuscated>/hubVirtualNetworkConnections/<obfuscated>/RemoteVirtualNetwork   : /subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualNetworks/<obfuscated>
EnableInternetSecurity : False
ProvisioningState      : Succeeded
RoutingConfiguration   : {
                           "AssociatedRouteTable": {
                             "Id": "/subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualHubs/<obfuscated>/hubRouteTables/<obfuscated>
                           },
                           "PropagatedRouteTables": {
                             "Labels": [
                               "<obfuscated>",
                               "<obfuscated>",
                               "<obfuscated>",
                               "<obfuscated>"
                             ],
                             "Ids": [
                               {
                                 "Id": "/subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualHubs/<obfuscated>/hubRouteTables/<obfuscated>"
                               }
                             ]
                           },
                           "VnetRoutes": {
                             "StaticRoutes": []
                           }
                         }

Currently this do not include the connectivity status of the VNET connection, including this would be a big improvement as it would open up possibilities for more automation to such as handling VNETs that are in a disconnected state.

Please add 🙏

Proposed implementation details (optional)

No response

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @vnetsuppgithub.

Issue Details

---

Description of the new feature

Sample output from Get-AzVirtualHubVnetConnection

Name                   : <obfuscated>
Id                     : /subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualHubs/<obfuscated>/hubVirtualNetworkConnections/<obfuscated>/RemoteVirtualNetwork   : /subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualNetworks/<obfuscated>
EnableInternetSecurity : False
ProvisioningState      : Succeeded
RoutingConfiguration   : {
                           "AssociatedRouteTable": {
                             "Id": "/subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualHubs/<obfuscated>/hubRouteTables/<obfuscated>
                           },
                           "PropagatedRouteTables": {
                             "Labels": [
                               "<obfuscated>",
                               "<obfuscated>",
                               "<obfuscated>",
                               "<obfuscated>"
                             ],
                             "Ids": [
                               {
                                 "Id": "/subscriptions/<obfuscated>/resourceGroups/<obfuscated>/providers/Microsoft.Network/virtualHubs/<obfuscated>/hubRouteTables/<obfuscated>"
                               }
                             ]
                           },
                           "VnetRoutes": {
                             "StaticRoutes": []
                           }
                         }

Currently this do not include the connectivity status of the VNET connection, including this would be a big improvement as it would open up possibilities for more automation to such as handling VNETs that are in a disconnected state.

Please add 🙏

Proposed implementation details (optional)

No response

Author:	feliasson
Assignees:	-
Labels:	feature-request, Service Attention, Network - Virtual Network, customer-reported
Milestone:	-

[feliasson]

Any updates here soon?

[glenbarnes-ll]

Would love to see this implemented. We have an ongoing issue and being able to automate a fix or at least alert would be very useful.

[feliasson]

Since this hasn't received any attention in 2.5 years, I felt compelled to return and demonstrate how I found out that you can retrieve the connectivityStatus property from a Microsoft.Network/virtualHubs/hubVirtualNetworkConnections resource.

We can achieve this by taking the resource ID of the hubVirtualNetworkConnections resource and use it with Get-AzResource to retrieve the connectivityStatus property.

$VirtualHub = Get-AzVirtualHub -Name <vhub-name> -ResourceGroupName <vhub-rg-name>
$VirtualHubVnetConnections = Get-AzVirtualHubVnetConnection -ParentObject $VirtualHub

# Simply demonstrated using the first connection resource ID from $VirtualHubVnetConnections
Get-AzResource -ResourceId $VirtualHubVnetConnections[0].Id | Select-Object -ExpandProperty properties