获取其他属性的扩展属性

huangapple
go评论123阅读模式
英文:

Getting extended properties with other properties

问题

我有一个 PowerShell 脚本，用于收集所有 Az 虚拟网络网关的信息，但似乎在获取资源名称时出现了问题。我得到的是带有红色箭头的截图中的名称，而不是带有黄色箭头的名称。

获取其他属性的扩展属性

  1. $gatewayDetailsArray = @()
  3. # 循环遍历每个订阅
  4. #foreach ($subscription in $subscriptions) {
  5.  #   Write-Host "Processing Subscription: $($subscription.Name)" -ForegroundColor Yellow
  7.     # 选择当前订阅
  8.   #   Select-AzSubscription -SubscriptionId $subscription.Id
  10.     # 获取当前订阅中的所有资源组
  11.     $resourceGroups = Get-AzResourceGroup
  13.     # 循环遍历每个资源组以获取虚拟网络网关
  14.     foreach ($resourceGroup in $resourceGroups) {
  15.        # $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -Property Name, GatewayType, VpnType, Sku -ExpandProperty IpConfigurations
  17.         
  18.        # 循环遍历每个虚拟网络网关并将详细信息添加到数组中
  19.         foreach ($gateway in $gateways) {
  20.             $details = @{
  21.                 Subscription = $subscription.Name
  22.                 ResourceGroupName = $gateway.ResourceGroupName
  23.                 Name = $gateway.Name
  24.                 GatewayType = $gateway.GatewayType
  25.                 VpnType = $gateway.VpnType
  26.                 GatewayIP = $gateway.GatewayIpAddress
  27.                 SKU = $gateway.Sku.Name
  28.                 VNET = ($gateway.subnet.id -split '/')[3]
  29.             }
  30.             $gatewayDetailsArray += New-Object PSObject -Property $details
  31.         }
  32.     }
  33. #}
  35. # 将网关详细信息数组导出为 CSV 文件
  36. $csvFilePath2 = "C:\temp\GatewayDetails_2.csv"
  37. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation
英文:

I have a PS script that collects information for all Az Virtual Network gateways but there seems to be an issue getting name of the resource. I am getting Name with red arrow in a screenshot instead of Name with Yellow arrow.

获取其他属性的扩展属性

  1. $gatewayDetailsArray = @()
  3. # Loop through each subscription
  4. #foreach ($subscription in $subscriptions) {
  5.  #   Write-Host "Processing Subscription: $($subscription.Name)" -ForegroundColor Yellow
  7.     # Select the current subscription
  8.   #   Select-AzSubscription -SubscriptionId $subscription.Id
  10.     # Get all resource groups in the current subscription
  11.     $resourceGroups = Get-AzResourceGroup
  13.     # Loop through each resource group to get virtual network gateways
  14.     foreach ($resourceGroup in $resourceGroups) {
  15.        # $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -Property Name, GatewayType, VpnType, Sku -ExpandProperty IpConfigurations
  17.         
  18.        # Loop through each virtual network gateway and add details to the array
  19.         foreach ($gateway in $gateways) {
  20.             $details = @{
  21.                 Subscription = $subscription.Name
  22.                 ResourceGroupName = $gateway.ResourceGroupName
  23.                 Name = $gateway.Name
  24.                 GatewayType = $gateway.GatewayType
  25.                 VpnType = $gateway.VpnType
  26.                 GatewayIP = $gateway.GatewayIpAddress
  27.                 SKU = $gateway.Sku.Name
  28.                 VNET = ($gateway.subnet.id -split '/')[-3]
  29.             }
  30.             $gatewayDetailsArray += New-Object PSObject -Property $details
  31.         }
  32.     }
  33. #}
  35. # Export the gateway details array to a CSV file
  36. $csvFilePath2 = "C:\temp\GatewayDetails_2.csv"
  37. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation
  40. </details>
  43. # 答案1
  44. **得分**: 1
  46. 要收集订阅中所有虚拟网络网关的信息，您可以使用以下修改后的脚本：
  48. ```c
  49. # $subscriptions = Get-AzSubscription
  51. # 初始化一个数组来存储网关详细信息
  52. $gatewayDetailsArray = @()
  54. # 循环遍历每个订阅
  55. #foreach ($subscription in $subscriptions) {
  56.  #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow
  58.     # 选择当前订阅
  59.   #   Select-AzSubscription -SubscriptionId $subscription.Id
  61.     # &lt;span class=&quot; active-doc-0&quot; data-doc-items=&quot;0&quot;&gt;获取当前订阅中的所有资源组[1](#doc-pos=0)&lt;/span&gt;
  62.     $resourceGroups = Get-AzResourceGroup
  64.     # 循环遍历每个资源组以获取虚拟网络网关
  65.     foreach ($resourceGroup in $resourceGroups) {
  66.         $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name
  68.         
  69.        # &lt;span class=&quot; active-doc-1&quot; data-doc-items=&quot;1&quot;&gt;循环遍历每个虚拟网络网关并将详细信息添加到数组中[2](#doc-pos=1)&lt;/span&gt;
  70.         foreach ($gateway in $gateways) {
  71.             $details = @{
  72.                 Subscription = $subscription.Name
  73.                 ResourceGroupName = $resourceGroup.ResourceGroupName
  74.                 Name = $gateway
  75.             }
  76.             $gatewayDetailsArray += New-Object PSObject -Property $details
  77.         }
  78.     }
  79. #}
  81. # 输出网关详细信息
  82. $gatewayDetailsArray | Format-Table -AutoSize
  84. # 将网关详细信息数组导出到CSV文件
  85. $csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
  86. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

输出：

获取其他属性的扩展属性

CSV文件导出的内容如下：

获取其他属性的扩展属性

  1. # $subscriptions = Get-AzSubscription
  3. # 初始化一个数组来存储网关详细信息
  4. $gatewayDetailsArray = @()
  6. # 循环遍历每个订阅
  7. #foreach ($subscription in $subscriptions) {
  8.  #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow
  10.     # 选择当前订阅
  11.   #   Select-AzSubscription -SubscriptionId $subscription.Id
  13.     # &lt;span class=&quot; active-doc-0&quot; data-doc-items=&quot;0&quot;&gt;获取当前订阅中的所有资源组[1](#doc-pos=0)&lt;/span&gt;
  14.     $resourceGroups = Get-AzResourceGroup
  16.     # 循环遍历每个资源组以获取虚拟网络网关
  17.     foreach ($resourceGroup in $resourceGroups) {
  18.         $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name
  20.         
  21.        # &lt;span class=&quot; active-doc-1&quot; data-doc-items=&quot;1&quot;&gt;循环遍历每个虚拟网络网关并将详细信息添加到数组中[2](#doc-pos=1)&lt;/span&gt;
  22.         foreach ($gateway in $gateways) {
  23.             $details = @{
  24.                 Subscription = $subscription.Name
  25.                 ResourceGroupName = $resourceGroup.ResourceGroupName
  26.                 Name = $gateway
  27.                 vpnType = $gateway.VpnType
  28.                 GatewayType = $gateway.GatewayType
  29.                 SKU = $gateway.Sku.Name
  30.                 VNET = ($gateway.subnet.id -split &#39;/&#39;)[-3]
  31.             }
  32.             $gatewayDetailsArray += New-Object PSObject -Property $details
  33.         }
  34.     }
  35. #}
  37. # 输出网关详细信息
  38. $gatewayDetailsArray | Format-Table -AutoSize
  41. $csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
  42. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

更新

> 我们希望输出以下内容。网关名称、订阅ID、资源组、VPN类型、SKU名称、来自IP配置的子网ID（参考原始截图），以便我们可以提取VNET详细信息。

您可以使用以下命令获取所有详细信息，如下所示：

  1. # 初始化一个数组来存储网关详细信息
  2. $gatewayDetailsArray = @()
  4. # 获取所有订阅
  5. $subscriptions = Get-AzSubscription
  7. # 循环遍历每个订阅
  8. foreach ($subscription in $subscriptions) {
  9.     Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow
  11.     # 选择当前订阅
  12.     Select-AzSubscription -SubscriptionId $subscription.Id
  14.     # 获取当前订阅中的所有资源组
  15.     $resourceGroups = Get-AzResourceGroup
  17.     # 循环遍历每个资源组以获取虚拟网络网关
  18.     foreach ($resourceGroup in $resourceGroups) {
  19.         $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName | Select-Object -Property Name, @{Name=&quot;SubscriptionID&quot;;Expression={$subscription.Id}}, ResourceGroupName, VpnType, @{Name=&quot;SKUName&quot;;Expression={$_.Sku.Name}}, @{Name=&quot;SubnetID&quot;;Expression={$_.IpConfigurations.Subnet.Id}}, @{Name=&quot;SubnetName&quot;;Expression={(Get-AzVirtualNetworkSubnetConfig -ResourceId $_.IpConfigurations.Subnet.Id).Name}}
  21.         # 循环遍历每个虚拟网络网关并将详细信息添加到数组中
  22.         foreach ($gateway in $gateways) {
  23.             $gatewayDetailsArray += $gateway
  24.         }
  25.     }
  26. }
  28. # 输出网关详细信息
  29. $gatewayDetailsArray | Format-Table -AutoSize Name, SubscriptionID, ResourceGroupName, VpnType, SKUName, SubnetID, SubnetName
  31. # 将网关详细信息数组导出到CSV文件
  32. $csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
  33. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

获取其他属性的扩展属性

获取其他属性的扩展属性

英文:

To collect information of all Virtual Network gateways in your subscription, you can make use of the below modified script:

  1. # $subscriptions = Get-AzSubscription
  3. # Initialize an array to store gateway details
  4. $gatewayDetailsArray = @()
  6. # Loop through each subscription
  7. #foreach ($subscription in $subscriptions) {
  8.  #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow
  10.     # Select the current subscription
  11.   #   Select-AzSubscription -SubscriptionId $subscription.Id
  13.     # &lt;span class=&quot; active-doc-0&quot; data-doc-items=&quot;0&quot;&gt;Get all resource groups in the current subscription[1](#doc-pos=0)&lt;/span&gt;
  14.     $resourceGroups = Get-AzResourceGroup
  16.     # Loop through each resource group to get virtual network gateways
  17.     foreach ($resourceGroup in $resourceGroups) {
  18.         $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name
  20.         
  21.        # &lt;span class=&quot; active-doc-1&quot; data-doc-items=&quot;1&quot;&gt;Loop through each virtual network gateway and add details to the array[2](#doc-pos=1)&lt;/span&gt;
  22.         foreach ($gateway in $gateways) {
  23.             $details = @{
  24.                 Subscription = $subscription.Name
  25.                 ResourceGroupName = $resourceGroup.ResourceGroupName
  26.                 Name = $gateway
  27.             }
  28.             $gatewayDetailsArray += New-Object PSObject -Property $details
  29.         }
  30.     }
  31. #}
  33. # Output the gateway details
  34. $gatewayDetailsArray | Format-Table -AutoSize
  36. # Export the gateway details array to a CSV file
  37. $csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
  38. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

Output:

获取其他属性的扩展属性

In csv, file got exported like below:

获取其他属性的扩展属性

  1. # $subscriptions = Get-AzSubscription
  3. # Initialize an array to store gateway details
  4. $gatewayDetailsArray = @()
  6. # Loop through each subscription
  7. #foreach ($subscription in $subscriptions) {
  8.  #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow
  10.     # Select the current subscription
  11.   #   Select-AzSubscription -SubscriptionId $subscription.Id
  13.     # &lt;span class=&quot; active-doc-0&quot; data-doc-items=&quot;0&quot;&gt;Get all resource groups in the current subscription[1](#doc-pos=0)&lt;/span&gt;
  14.     $resourceGroups = Get-AzResourceGroup
  16.     # Loop through each resource group to get virtual network gateways
  17.     foreach ($resourceGroup in $resourceGroups) {
  18.         $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name
  20.         
  21.        # &lt;span class=&quot; active-doc-1&quot; data-doc-items=&quot;1&quot;&gt;Loop through each virtual network gateway and add details to the array[2](#doc-pos=1)&lt;/span&gt;
  22.         foreach ($gateway in $gateways) {
  23.             $details = @{
  24.                 Subscription = $subscription.Name
  25.                 ResourceGroupName = $resourceGroup.ResourceGroupName
  26.                 Name = $gateway
  27.                 vpnType = $gateway.VpnType
  28.                 GatewayType = $gateway.GatewayType
  29.                 SKU = $gateway.Sku.Name
  30.                 VNET = ($gateway.subnet.id -split &#39;/&#39;)[-3]
  31.             }
  32.             $gatewayDetailsArray += New-Object PSObject -Property $details
  33.         }
  34.     }
  35. #}
  37. # Output the gateway details
  38. $gatewayDetailsArray | Format-Table -AutoSize
  41. $csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
  42. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

Update

> We would like below in output. Gatway name, Subscription ID, Resource group, VPNType, SKU name, Subnet ID from IPconfigurations (refer to original screenshot) so that we can extract VNET detail

You can make use of below command to get all the details like below:

  1. # Initialize an array to store gateway details
  2. $gatewayDetailsArray = @()
  4. # Get all subscriptions
  5. $subscriptions = Get-AzSubscription
  7. # Loop through each subscription
  8. foreach ($subscription in $subscriptions) {
  9.     Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow
  11.     # Select the current subscription
  12.     Select-AzSubscription -SubscriptionId $subscription.Id
  14.     # Get all resource groups in the current subscription
  15.     $resourceGroups = Get-AzResourceGroup
  17.     # Loop through each resource group to get virtual network gateways
  18.     foreach ($resourceGroup in $resourceGroups) {
  19.         $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName | Select-Object -Property Name, @{Name=&quot;SubscriptionID&quot;;Expression={$subscription.Id}}, ResourceGroupName, VpnType, @{Name=&quot;SKUName&quot;;Expression={$_.Sku.Name}}, @{Name=&quot;SubnetID&quot;;Expression={$_.IpConfigurations.Subnet.Id}}, @{Name=&quot;SubnetName&quot;;Expression={(Get-AzVirtualNetworkSubnetConfig -ResourceId $_.IpConfigurations.Subnet.Id).Name}}
  21.         # Loop through each virtual network gateway and add details to the array
  22.         foreach ($gateway in $gateways) {
  23.             $gatewayDetailsArray += $gateway
  24.         }
  25.     }
  26. }
  28. # Output the gateway details
  29. $gatewayDetailsArray | Format-Table -AutoSize Name, SubscriptionID, ResourceGroupName, VpnType, SKUName, SubnetID, SubnetName
  31. # Export the gateway details array to a CSV file
  32. $csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
  33. $gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

获取其他属性的扩展属性

获取其他属性的扩展属性

huangapple
  • 本文由 发表于 2023年8月9日 10:30:34
  • 转载请务必保留本文链接：https://go.coder-hub.com/76864212.html
  • azure
  • azure-virtual-network
  • powershell
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定