Vnet Subnet

Handian Sudianto 4,116

Hello,

Can we know and export if possible list of resources (VM, APP service etc.) for specific subnet?

KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-03-24T13:43:01.9966667+00:00

@Handian Sudianto

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

Can you please elaborate your ask.

By export, do you mean a JSON or Excel file with all the resources' Resource ID ?

Cheers,

Kapil
Handian Sudianto 4,116 Reputation points

2023-03-27T09:07:30.4933333+00:00

Hi @kapilananth-MSFT

I just want to export all resource (VM, Private Endpoint etc.) only for specific subnet.
KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-03-27T09:13:19.5933333+00:00

@Handian Sudianto

I have provided a script below to do so.

Please review it and if it had helped, please accept the answer

Cheers,

Kapil

Accepted answer

KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-03-27T09:01:32.4233333+00:00
@Handian Sudianto

You can use the below script to get the list of connected NICs, Private EndPoints and VNet Integrated resources for all the subnets in the VNet.

$Vnet = Get-AzVirtualNetwork -Name <VNet Name> -ResourceGroup <RG Name> foreach ($subnet in $Vnet.Subnets){ Write-Host "Name: " $subnet.Name Write-Host "Address Range: " $subnet.AddressPrefix Write-Host "`n" Write-Host "List of Private EndPoints:" foreach ($pe in $subnet.PrivateEndPoints){ $pe.Id } Write-Host "`n" Write-Host "List of Connected NICs:" foreach ($nic in $subnet.IpConfigurations){ $nic.Id } Write-Host "`n" Write-Host "VNet Integration" foreach ($sal in $subnet.ServiceAssociationLinks ){ $sal.Link } Write-Host "`n" Write-Host "End of Subnet" Write-Host "`n" }

Kindly let us know if this helps or you need further assistance on this issue.

Thanks,

Kapil

Please don’t forget to close the thread by clicking "Accept the answer" wherever the information provided helps you, as this can be beneficial to other community members.
Please sign in to rate this answer.
Handian Sudianto 4,116 Reputation points

2023-03-28T01:54:18.09+00:00

Hi @kapilananth-MSFT

Great, but how we can export the result to csv?

Handian Sudianto 4,116 Reputation points

2023-03-28T01:56:34.03+00:00

Hi @KapilAnanth-MSFT

Great, but how we can export the result to csv?

KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-03-28T04:57:59.92+00:00

@Handian Sudianto

Can you please try the below?

$Vnet = Get-AzVirtualNetwork -Name <VNet Name> -ResourceGroup <RG Name> foreach ($subnet in $Vnet.Subnets){ $data = @() foreach ($nic in $subnet.IpConfigurations){ $data += $nic.Id } foreach ($pe in $subnet.PrivateEndPoints){ $data += $pe.Id } foreach ($sal in $subnet.ServiceAssociationLinks ){ $data += $sal.Link } $data | ForEach { [PSCustomObject]@{ResourceID = $_} } | Export-Csv "C:\$($subnet.Name)_subnet.csv" -NoTypeInformation }

Thanks,

Kapil

Please don’t forget to close the thread by clicking "Accept the answer" wherever the information provided helps you, as this can be beneficial to other community members.

Handian Sudianto 4,116 Reputation points

2023-03-28T05:11:27.67+00:00

Hi @kapilananth-MSFT

The csv file is empty and the size is 0 KB

KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-03-28T06:02:18.1833333+00:00

Hi @Handian Sudianto

This works fine in my Lab

Do you actually have connected devices in the VNet you are testing?

You can check this from "Connected Devices" section of the VNet

Cheers,

Kapil

Handian Sudianto 4,116 Reputation points

2023-03-28T06:18:13.4233333+00:00

Hello,

Do you actually have connected devices in the VNet you are testing? YES.

Previously when using given 1st script, i can see all devices connected to the each subnet in the console, but when using 2nd script the csv file is empty.

KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-03-28T09:19:39.7866667+00:00

Hi @Handian Sudianto

Can you please try the script in a different machine?

Also, can you please run the script so that the file gets saved in a different location?

Please make sure you are running Powershell as Admin

If the above does not help, please reach out to us in azcommunity[At]Microsoft[Dot]com

Subject : Attn Kaananth

Thread URL: Link to this thread.

Subscription ID : Subscription ID of your Azure Vnet

Cheers,

Kapil

Handian Sudianto 4,116 Reputation points

2023-03-29T03:09:23.1+00:00

Hello,

On other machine i got error

"Get-AzVirtualNetwork : The term 'Get-AzVirtualNetwork' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again."

Need import what module?

KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-03-29T13:08:47.88+00:00

Hi @Handian Sudianto

You must install the Azure Az Module for Powershell

Refer : https://learn.microsoft.com/en-us/powershell/azure/install-az-ps?view=azps-9.5.0#offline-installation

Handian Sudianto 4,116 Reputation points

2023-03-30T02:06:54.32+00:00

Hello,

I got this error

KapilAnanth-MSFT 35,001 Reputation points Microsoft Employee

2023-04-03T14:45:58.4933333+00:00

Hi @Handian Sudianto,

Did you Set the Az Context after logging in?

Make sure the correct subscription ID is selected

Cheers,

Kapil
Sign in to comment

1 additional answer

Sedat SALMAN 13,160

yes you can do by using the following azure cli code block

-- note install azure cli before running code block

# Log in to your Azure account
az login
# Set your subscription if you have multiple subscriptions
az account set --subscription "<YourSubscriptionID>"
# Retrieve the specific subnet's ID
subnet_id=$(az network vnet subnet show --name "<SubnetName>" --vnet-name "<VnetName>" --resource-group "<ResourceGroupName>" --query "id" -o tsv)
# List resources associated with the specific subnet using the subnet ID
resources=$(az resource list --query "[?contains(properties.subnet.id, '${subnet_id}')]" -o json)
# Export the list of resources to a JSON file
echo $resources > resources_in_subnet.json
# Optional: Export the list of resources to a CSV file
az resource list --query "[?contains(properties.subnet.id, '${subnet_id}')].{Name:name, Type:type, Location:location}" -o table > resources_in_subnet.csv

also with the following powershell code block

# Log in to your Azure account
Connect-AzAccount
# Set your subscription if you have multiple subscriptions
Set-AzContext -SubscriptionId "<YourSubscriptionID>"
# Retrieve the specific subnet's ID
$subnet = Get-AzVirtualNetworkSubnetConfig -Name "<SubnetName>" -VirtualNetwork (Get-AzVirtualNetwork -ResourceGroupName "<ResourceGroupName>" -Name "<VnetName>")
$subnetId = $subnet.Id
# List resources associated with the specific subnet using the subnet ID
$resources = Get-AzResource | Where-Object { $_.Properties.Subnet -and $_.Properties.Subnet.Id -eq $subnetId }
# Export the list of resources to a JSON file
$resources | ConvertTo-Json -Depth 4 | Set-Content -Path "resources_in_subnet.json"
# Optional: Export the list of resources to a CSV file
$resources | Select-Object -Property Name, ResourceType, Location | Export-Csv -Path "resources_in_subnet.csv" -NoTypeInformation

Handian Sudianto 4,116 Reputation points

2023-03-27T02:46:32.2666667+00:00

Hello @Sedat SALMAN

$subnet = Get-AzVirtualNetworkSubnetConfig -Name "<SubnetName>" -VirtualNetwork (Get-AzVirtualNetwork -ResourceGroupName "<ResourceGroupName>" -Name "<VnetName>")

Can we query just by subnet name and ignoree RG name and VnetName?

Sedat SALMAN 13,160

Yes, you can query by just the subnet name without specifying the Resource Group name and VnetName

if it returns multiple subnets with the same name you can use where

something like



Connect-AzAccount

Set-AzContext -SubscriptionId "<YourSubscriptionID>"

$subnetName = "<SubnetName>"
$subnets = Get-AzVirtualNetwork -ExpandResource "subnets" | ForEach-Object { $_.Subnets } | Where-Object { $_.Name -eq $subnetName }

foreach ($subnet in $subnets) {
    $subnetId = $subnet.Id

    $resources = Get-AzResource | Where-Object { $_.Properties.Subnet -and $_.Properties.Subnet.Id -eq $subnetId }

    $resources | ConvertTo-Json -Depth 4 | Set-Content -Path "resources_in_subnet_$($subnet.Name).json"

    $resources | Select-Object -Property Name, ResourceType, Location | Export-Csv -Path "resources_in_subnet_$($subnet.Name).csv" -NoTypeInformation
}

Handian Sudianto 4,116 Reputation points

2023-03-27T05:55:52.0366667+00:00

Hello @Sedat SALMAN

there are prompt asked for name, what should i fill?