question

FahadNoaman-7438 avatar image
0 Votes"
FahadNoaman-7438 asked FahadNoaman-7438 commented

kusto Query to get details of VNETs and its Address space.

Query from Kusto to get details of VNETs and its Address space on all the subcribtion.

azure-virtual-network
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

suvasara-MSFT avatar image
0 Votes"
suvasara-MSFT answered FahadNoaman-7438 commented

@FahadNoaman-7438, Please try running this query in Azure resource graph explorer,
132457-image.png



image.png (238.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you so much for the query.

Appreciate a lot.

0 Votes 0 ·
suvasara-MSFT avatar image
0 Votes"
suvasara-MSFT answered FahadNoaman-7438 commented

@FahadNoaman-7438 , Try this,

 resources
    
 | where type == "microsoft.network/virtualnetworks"
    
 | extend AddressSpace_AddressPrefixes = tostring(properties.['addressSpace'].['addressPrefixes'])



Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I get this.

Please provide below info when asking for support: timestamp = 2021-09-15T06:58:50.3716524Z, correlationId = 340a9a2e-66e0-44c4-a472-421de73de348. (Code:BadRequest)

Details:
Query is invalid. Please refer to the documentation for the Azure Resource Graph service and fix the error before retrying. (Code:InvalidQuery)
ParserFailure (Code:ParserFailure)
ParserFailure (Code:ParserFailure)

0 Votes 0 ·