Export CSV Table of All Azure Web Apps Configuration in Subscription
At Ritter Insurance Marketing we utilize Azure Web Apps for hosting many of our web applications. Azure Web Apps is a platform as a service (PaaS) offering from Microsoft, enabling their customers to host web applications without managing and maintaining the server infrastructure.
Given the number of Azure Web Apps we have, reporting on and managing configuration across the entire environment can be difficult. With each app seperate, it is difficult to get an overall view of configuration (AlwaysOn, HTTP2, etc.), as well as app settings and connection strings.
Answering even simple questions about configuration across the board can be challenging when each application is a seperate unrelated entity. In our case, it helped find connection strings needing an update due to a deprecation.
Fortunately, the Azure CLI enables programmatic access to these configuration items. Writing a script to compile the data and output to CSV is exactly what we did! It’s on GitHub at https://github.com/ritterim/azure-web-apps-configuration-table-exporter.
- Install Node.js (if not already installed).
- Install Azure CLI.
- Login using Azure CLI (
- Clone or download the ritterim/azure-web-apps-configuration-table-exporter repository.
node ./index.jsto get a generated filename. It can optionally be specified as
node ./index.js --file output.csv.
- Watch and wait, depending on the number of web applications in the current subscription it can take considerable time.
Found a bug or have an idea? We welcome contributions at the GitHub repository.
We hope you find this tool useful!