Generating Reports for VNETs, Subnet, Connected Devices

Question

I am seeking instruction how to generate reports from within the Portal.

Information being sought is the number of connected devices per subnet.

The number can be established by viewing 'available ip addresses', but thats too long as we have hundreds of subnets and thousands of VMs.

Thank you

Answer 1

Hello @Ajaz Akhtar Nawaz

Welcome to Microsoft Q&A Platform,

Have you tried using Resource Graph? Please check the below article with some sample queries for network resources:

https://learn.microsoft.com/en-us/azure/networking/fundamentals/resource-graph-samples?tabs=azure-cli

I hope this helps!

----------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

@Ajaz Akhtar Nawaz :

You can try out the following Powershell script and export it as CSV :

$result=Get-AzVirtualNetwork -Name '<vnet name>'  -ResourceGroupName '<group nmae>' -ExpandResource 'subnets/ipConfigurations'   
  
$result.Subnets[0].IpConfigurations  

Answer 3

$result=Get-AzVirtualNetwork -Name ‘AAA-VNET-0001’ -ResourceGroupName ‘AAA-RG-00000002-000’ -ExpandResource 'subnets/ipConfigurations'

When I run the above script, and btw I know very little about Powershell, I receive the following error:

Get-AzVirtualNetwork: Resource group 'AAA-RG-00000002-000' could not be found.
StatusCode: 404
ReasonPhrase: Not Found
ErrorCode: ResourceGroupNotFound
ErrorMessage: Resource group 'AAA-RG-00000002-000' could not be found.
OperationID : 072b7eb1-cfb2-4140-xxxxxxxxxxx <removed>