2023年8月9日 10:30:34go评论78阅读模式

英文:

Getting extended properties with other properties

问题

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

$gatewayDetailsArray = @()

# 循环遍历每个订阅
#foreach ($subscription in $subscriptions) {
 #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # 选择当前订阅
  #   Select-AzSubscription -SubscriptionId $subscription.Id

    # 获取当前订阅中的所有资源组
    $resourceGroups = Get-AzResourceGroup

    # 循环遍历每个资源组以获取虚拟网络网关
    foreach ($resourceGroup in $resourceGroups) {
       # $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -Property Name, GatewayType, VpnType, Sku -ExpandProperty IpConfigurations

        
       # 循环遍历每个虚拟网络网关并将详细信息添加到数组中
        foreach ($gateway in $gateways) {
            $details = @{
                Subscription = $subscription.Name
                ResourceGroupName = $gateway.ResourceGroupName
                Name = $gateway.Name
                GatewayType = $gateway.GatewayType
                VpnType = $gateway.VpnType
                GatewayIP = $gateway.GatewayIpAddress
                SKU = $gateway.Sku.Name
                VNET = ($gateway.subnet.id -split '/')[3]
            }
            $gatewayDetailsArray += New-Object PSObject -Property $details
        }
    }
#}

# 将网关详细信息数组导出为 CSV 文件
$csvFilePath2 = "C:\temp\GatewayDetails_2.csv"
$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.

$gatewayDetailsArray = @()

# Loop through each subscription
#foreach ($subscription in $subscriptions) {
 #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # Select the current subscription
  #   Select-AzSubscription -SubscriptionId $subscription.Id

    # Get all resource groups in the current subscription
    $resourceGroups = Get-AzResourceGroup

    # Loop through each resource group to get virtual network gateways
    foreach ($resourceGroup in $resourceGroups) {
       # $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -Property Name, GatewayType, VpnType, Sku -ExpandProperty IpConfigurations

        
       # Loop through each virtual network gateway and add details to the array
        foreach ($gateway in $gateways) {
            $details = @{
                Subscription = $subscription.Name
                ResourceGroupName = $gateway.ResourceGroupName
                Name = $gateway.Name
                GatewayType = $gateway.GatewayType
                VpnType = $gateway.VpnType
                GatewayIP = $gateway.GatewayIpAddress
                SKU = $gateway.Sku.Name
                VNET = ($gateway.subnet.id -split &#39;/&#39;)[-3]
            }
            $gatewayDetailsArray += New-Object PSObject -Property $details
        }
    }
#}

# Export the gateway details array to a CSV file
$csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
$gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation


</details>


# 答案1
**得分**: 1

要收集订阅中所有虚拟网络网关的信息，您可以使用以下修改后的脚本：

```c
# $subscriptions = Get-AzSubscription

# 初始化一个数组来存储网关详细信息
$gatewayDetailsArray = @()

# 循环遍历每个订阅
#foreach ($subscription in $subscriptions) {
 #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # 选择当前订阅
  #   Select-AzSubscription -SubscriptionId $subscription.Id

    # &lt;span class=&quot; active-doc-0&quot; data-doc-items=&quot;0&quot;&gt;获取当前订阅中的所有资源组[1](#doc-pos=0)&lt;/span&gt;
    $resourceGroups = Get-AzResourceGroup

    # 循环遍历每个资源组以获取虚拟网络网关
    foreach ($resourceGroup in $resourceGroups) {
        $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name

        
       # &lt;span class=&quot; active-doc-1&quot; data-doc-items=&quot;1&quot;&gt;循环遍历每个虚拟网络网关并将详细信息添加到数组中[2](#doc-pos=1)&lt;/span&gt;
        foreach ($gateway in $gateways) {
            $details = @{
                Subscription = $subscription.Name
                ResourceGroupName = $resourceGroup.ResourceGroupName
                Name = $gateway
            }
            $gatewayDetailsArray += New-Object PSObject -Property $details
        }
    }
#}

# 输出网关详细信息
$gatewayDetailsArray | Format-Table -AutoSize

# 将网关详细信息数组导出到CSV文件
$csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
$gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

输出：

获取其他属性的扩展属性

CSV文件导出的内容如下：

获取其他属性的扩展属性

# $subscriptions = Get-AzSubscription

# 初始化一个数组来存储网关详细信息
$gatewayDetailsArray = @()

# 循环遍历每个订阅
#foreach ($subscription in $subscriptions) {
 #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # 选择当前订阅
  #   Select-AzSubscription -SubscriptionId $subscription.Id

    # &lt;span class=&quot; active-doc-0&quot; data-doc-items=&quot;0&quot;&gt;获取当前订阅中的所有资源组[1](#doc-pos=0)&lt;/span&gt;
    $resourceGroups = Get-AzResourceGroup

    # 循环遍历每个资源组以获取虚拟网络网关
    foreach ($resourceGroup in $resourceGroups) {
        $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name

        
       # &lt;span class=&quot; active-doc-1&quot; data-doc-items=&quot;1&quot;&gt;循环遍历每个虚拟网络网关并将详细信息添加到数组中[2](#doc-pos=1)&lt;/span&gt;
        foreach ($gateway in $gateways) {
            $details = @{
                Subscription = $subscription.Name
                ResourceGroupName = $resourceGroup.ResourceGroupName
                Name = $gateway
                vpnType = $gateway.VpnType
                GatewayType = $gateway.GatewayType
                SKU = $gateway.Sku.Name
                VNET = ($gateway.subnet.id -split &#39;/&#39;)[-3]
            }
            $gatewayDetailsArray += New-Object PSObject -Property $details
        }
    }
#}

# 输出网关详细信息
$gatewayDetailsArray | Format-Table -AutoSize


$csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
$gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

更新

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

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

# 初始化一个数组来存储网关详细信息
$gatewayDetailsArray = @()

# 获取所有订阅
$subscriptions = Get-AzSubscription

# 循环遍历每个订阅
foreach ($subscription in $subscriptions) {
    Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # 选择当前订阅
    Select-AzSubscription -SubscriptionId $subscription.Id

    # 获取当前订阅中的所有资源组
    $resourceGroups = Get-AzResourceGroup

    # 循环遍历每个资源组以获取虚拟网络网关
    foreach ($resourceGroup in $resourceGroups) {
        $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}}

        # 循环遍历每个虚拟网络网关并将详细信息添加到数组中
        foreach ($gateway in $gateways) {
            $gatewayDetailsArray += $gateway
        }
    }
}

# 输出网关详细信息
$gatewayDetailsArray | Format-Table -AutoSize Name, SubscriptionID, ResourceGroupName, VpnType, SKUName, SubnetID, SubnetName

# 将网关详细信息数组导出到CSV文件
$csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
$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:

# $subscriptions = Get-AzSubscription

# Initialize an array to store gateway details
$gatewayDetailsArray = @()

# Loop through each subscription
#foreach ($subscription in $subscriptions) {
 #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # Select the current subscription
  #   Select-AzSubscription -SubscriptionId $subscription.Id

    # &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;
    $resourceGroups = Get-AzResourceGroup

    # Loop through each resource group to get virtual network gateways
    foreach ($resourceGroup in $resourceGroups) {
        $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name

        
       # &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;
        foreach ($gateway in $gateways) {
            $details = @{
                Subscription = $subscription.Name
                ResourceGroupName = $resourceGroup.ResourceGroupName
                Name = $gateway
            }
            $gatewayDetailsArray += New-Object PSObject -Property $details
        }
    }
#}

# Output the gateway details
$gatewayDetailsArray | Format-Table -AutoSize

# Export the gateway details array to a CSV file
$csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
$gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

Output:

获取其他属性的扩展属性

In csv, file got exported like below:

获取其他属性的扩展属性

# $subscriptions = Get-AzSubscription

# Initialize an array to store gateway details
$gatewayDetailsArray = @()

# Loop through each subscription
#foreach ($subscription in $subscriptions) {
 #   Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # Select the current subscription
  #   Select-AzSubscription -SubscriptionId $subscription.Id

    # &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;
    $resourceGroups = Get-AzResourceGroup

    # Loop through each resource group to get virtual network gateways
    foreach ($resourceGroup in $resourceGroups) {
        $gateways = Get-AzVirtualNetworkGateway -ResourceGroupName $resourceGroup.ResourceGroupName  | Select-Object -ExpandProperty Name

        
       # &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;
        foreach ($gateway in $gateways) {
            $details = @{
                Subscription = $subscription.Name
                ResourceGroupName = $resourceGroup.ResourceGroupName
                Name = $gateway
                vpnType = $gateway.VpnType
                GatewayType = $gateway.GatewayType
                SKU = $gateway.Sku.Name
                VNET = ($gateway.subnet.id -split &#39;/&#39;)[-3]
            }
            $gatewayDetailsArray += New-Object PSObject -Property $details
        }
    }
#}

# Output the gateway details
$gatewayDetailsArray | Format-Table -AutoSize


$csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
$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:

# Initialize an array to store gateway details
$gatewayDetailsArray = @()

# Get all subscriptions
$subscriptions = Get-AzSubscription

# Loop through each subscription
foreach ($subscription in $subscriptions) {
    Write-Host &quot;Processing Subscription: $($subscription.Name)&quot; -ForegroundColor Yellow

    # Select the current subscription
    Select-AzSubscription -SubscriptionId $subscription.Id

    # Get all resource groups in the current subscription
    $resourceGroups = Get-AzResourceGroup

    # Loop through each resource group to get virtual network gateways
    foreach ($resourceGroup in $resourceGroups) {
        $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}}

        # Loop through each virtual network gateway and add details to the array
        foreach ($gateway in $gateways) {
            $gatewayDetailsArray += $gateway
        }
    }
}

# Output the gateway details
$gatewayDetailsArray | Format-Table -AutoSize Name, SubscriptionID, ResourceGroupName, VpnType, SKUName, SubnetID, SubnetName

# Export the gateway details array to a CSV file
$csvFilePath2 = &quot;C:\temp\GatewayDetails_2.csv&quot;
$gatewayDetailsArray | Export-Csv -Path $csvFilePath2 -NoTypeInformation

获取其他属性的扩展属性

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

获取其他属性的扩展属性

问题

更新

Update

用分割的输出替换文件名

VS Code：在运行函数后，Azure工作区文件夹不会显示。

使用静态文本重命名文件，删除 ‘0’ 后。

Translation language pair that not including English

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论