Export Azure Vnet Confguration Settings to a CSV file

Question

Hi,

Does anyone know how I can modify my pre-exisiting script to export all settings into a csv for my vnet configuration?

$vnets =Get-AzVirtualNetwork|
Select-Object SubscriptionName,ResourceGroupName,Name, @{
label='AddressSpace'
expression={$.AddressSpace.AddressPrefix}}, @{
label='SubnetName'
expression={$.Subnets.Name}
}, @{
label='SubnetAddressSpace'
expression={$_.Subnets.AddressPrefix}
}

$vnets | convertto-csv

Answer 1

Hi @DeHaven Graham ,

I am not sure what's your definition of "all settings" but maybe this is helpful to go further with your script:

$a = "------------------------------------------------------------------------------------------------------------------"              
$vnetObjs = Get-AzVirtualNetwork   
foreach ($vnetobj in $vnetObjs) {  
    $resultvNet = "vNet Name: " + $vnetObj.Name  
    $resultvNet  
    $resultPeering = "Peering: " + (Get-AzVirtualNetworkPeering -Name "*" -VirtualNetwork $vnetObj.Name -ResourceGroupName $vnetobj.ResourceGroupName | Select-Object -ExpandProperty Name)  
    $resultPeering  
    if ($vnetobj.DhcpOptions.DnsServers){  
        $resultDNS = "DNS Server: " + $vnetobj.DhcpOptions.DnsServers  
        }  
    else {  
        $resultDNS = "DNS Server: Azure Default"   
        }  
    $resultDNS  
    $resultIPAddress = $vnetobj | Get-AzVirtualNetworkSubnetConfig | Select-Object Name,AddressPrefix  
    $resultIPAddress  
    $a   
    }      

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten