turbot/steampipe-mod-azure-insights

Dashboard: Azure App Service Web App Inventory Report

This report answers the following questions:

  • How many web apps are there across my subscriptions?
  • What types (kinds) of web apps are in use?
  • What is the state and enabled status of each web app?
  • Which web apps enforce HTTPS-only access?
  • Which web apps require client certificates?
  • What are the default hostnames for each web app?
  • Which web apps have custom hostnames disabled?
  • Which web apps are reserved instances?
  • How are web apps distributed across subscriptions, resource groups, and regions?

The inventory report includes:

  • Total count of web apps
  • Detailed list of all web apps with:
    • App name and kind
    • State and enabled status
    • Security settings (HTTPS, client certificates)
    • Hostname configuration
    • Reserved instance status
    • Resource organization (subscription, resource group, region)
    • Associated tags
This dashboard contains 1 card and 1 table.

Usage

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-azure-insights

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select Azure App Service Web App Inventory Report dashboard.

You could also snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe dashboard run azure_insights.dashboard.app_service_web_app_inventory_report --share

Queries

This dashboard uses the the following queries:
select count(*) as "Web Apps" from azure_app_service_web_app;

Tags