Hello, Can we export all azure web app to the CSV including the url name / default domain?

Hi, Sure. Basic example code to get you started below: Get-AzWebApp|Select-Object -Property Name,DefaultHostName|Export-Csv -Path .\WebApps.csv -NoTypeInformation NOTE: above will include Function Apps, API Apps, and other apps that are part of app service platform in addition to Web Apps. You need to decide which precise properties you want to export to CSV file. Depending on the property, it may be as simple as adding it to the comma-separated list in the above command. "DefaultHostName" above is <hostname>.azurewebsites.net, which might not be what you need. Below are list of properties to choose from: https://learn.microsoft.com/en-us/dotnet/api/microsoft.azure.management.websites.models.site?view=azure-dotnet#properties If you test and are having trouble getting a specific property you need to show up in the file add a comment and I will help with required code change(s). If the above is helpful please click Accept Answer. Thanks. -TP

Export Web App List - Microsoft Q&A

Accepted answer

TP 89,011 Reputation points

2023-03-20T07:08:06.4966667+00:00
Hi,

Sure. Basic example code to get you started below:

Get-AzWebApp|Select-Object -Property Name,DefaultHostName|Export-Csv -Path .\WebApps.csv -NoTypeInformation

NOTE: above will include Function Apps, API Apps, and other apps that are part of app service platform in addition to Web Apps.

You need to decide which precise properties you want to export to CSV file. Depending on the property, it may be as simple as adding it to the comma-separated list in the above command. "DefaultHostName" above is <hostname>.azurewebsites.net, which might not be what you need. Below are list of properties to choose from:

https://learn.microsoft.com/en-us/dotnet/api/microsoft.azure.management.websites.models.site?view=azure-dotnet#properties

If you test and are having trouble getting a specific property you need to show up in the file add a comment and I will help with required code change(s).

If the above is helpful please click Accept Answer.

Thanks.

-TP
Please sign in to rate this answer.
Handian Sudianto 4,811 Reputation points

2023-03-20T07:43:19.7233333+00:00

currently i used this command but i need to export the result.

$slotNames = Get-AzWebApp | Get-AzWebAppSlot

$result = $siteNames + $slotNames

$result | Format-Table -Property Name, Type, ResourceGroup, HostNames,location, id

TP 89,011 Reputation points

2023-03-20T10:03:21.18+00:00

What is definition for $siteNames variable? I was going to modify your command but am unsure what should be in $siteNames

Handian Sudianto 4,811 Reputation points

2023-03-21T00:42:43.69+00:00

Hello,

sorry , here is my full script and i just want export the result to the csv

Get Azure WebApps across all resource groups in your Subscription

$Subscriptions=Get-AzSubscription
foreach ($sub in $Subscriptions) {
   $siteNames = Get-AzWebApp
}
   # Get Azure WebApp Slots across all resource groups in your Subscription
   $slotNames = Get-AzWebApp | Get-AzWebAppSlot
   # Combine the result
   $result = $siteNames + $slotNames
   # Extract necessary properties from the result
   $result | Format-Table -Property Name, Type, ResourceGroup, HostNames,location, id

TP 89,011 Reputation points

2023-03-21T10:21:32.5366667+00:00

Okay. See updated version below:

$Subscriptions=Get-AzSubscription foreach ($sub in $Subscriptions) { $siteNames = Get-AzWebApp } # Get Azure WebApp Slots across all resource groups in your Subscription $slotNames = Get-AzWebApp | Get-AzWebAppSlot # Combine the result $result = $siteNames + $slotNames # Extract necessary properties from the result $hostNames = @{l="HostNames";e={$_.HostNames -Join ","}} $result | Select-Object -Property Name,Type,ResourceGroup,$hostNames,Location,Id|Export-Csv -Path .\Webapps.csv -NoTypeInformation

Thanks.

Handian Sudianto 4,811 Reputation points

2023-03-23T00:31:55.8966667+00:00

Hello,

it's work, thanks.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Export Web App List

Get Azure WebApps across all resource groups in your Subscription

0 additional answers

Your answer