Table: azure_app_service_plan - Query Azure App Service Plans using SQL

Azure App Service Plan is a service within Microsoft Azure that defines a set of compute resources for a web app to run. These compute resources are analogous to the server farm in conventional web hosting. It specifies the number of VM instances to allocate, the size of each instance, and the pricing tier.

Table Usage Guide

The azure_app_service_plan table provides insights into the App Service Plans within Microsoft Azure. As a Cloud Engineer, explore App Service Plan-specific details through this table, including the number of web apps, capacity, maximum number of workers, and other associated metadata. Utilize it to uncover information about each App Service Plan, such as its current status, tier, and the geographical location of the data center where the plan is running.

Examples

App service plan SKU info

Explore the details of your Azure App Service Plan to understand the specifics of your service tier and capacity. This can help you assess if your current plan aligns with your application's requirements and if there is a need for scaling or downgrading.

select
  name,
  sku_family,
  sku_name,
  sku_size,
  sku_tier,
  sku_capacity
from
  azure_app_service_plan;

select
  name,
  sku_family,
  sku_name,
  sku_size,
  sku_tier,
  sku_capacity
from
  azure_app_service_plan;

List of Hyper-V container app service plan

Explore which Azure App Service Plans are using Hyper-V containers. This can help determine the areas in which these specific types of containers are being utilized, aiding in resource management and optimization.

select
  name,
  hyper_v,
  kind,
  region
from
  azure_app_service_plan
where
  hyper_v;

select
  name,
  hyper_v,
  kind,
  region
from
  azure_app_service_plan
where
  hyper_v = 1;

List of App service plan that owns spot instances

Explore which Azure App Service Plans are utilizing spot instances. This is useful for managing costs and understanding the distribution of your resources.

select
  name,
  is_spot,
  kind,
  region,
  resource_group
from
  azure_app_service_plan
where
  is_spot;

select
  name,
  is_spot,
  kind,
  region,
  resource_group
from
  azure_app_service_plan
where
  is_spot = 1;

Control examples

Schema for azure_app_service_plan

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
apps	jsonb		Site a web app, a mobile app backend, or an API app.
cloud_environment	text		The Azure Cloud Environment.
elastic_scale_enabled	boolean		Specifies if ElasticScale is enabled for the App Service plan
geo_region	text		Geographical location for the App Service plan
hyper_v	boolean		Specify whether resource is Hyper-V container app service plan
id	text		Contains ID to identify an app service plan uniquely
is_spot	boolean		Specify whether this App Service Plan owns spot instances, or not
is_xenon	boolean		Specify whether resource is Hyper-V container app service plan
kind	text		Contains the kind of the resource
maximum_elastic_worker_count	bigint		Maximum number of total workers allowed for this ElasticScaleEnabled App Service Plan
maximum_number_of_workers	bigint		Maximum number of instances that can be assigned to this App Service plan
name	text	=	The friendly name that identifies the app service plan
per_site_scaling	boolean		Specify whether apps assigned to this App Service plan can be scaled independently
provisioning_state	text		Provisioning state of the App Service Plan
region	text		The Azure region/location in which the resource is located.
reserved	boolean		Specify whether the resource is Linux app service plan, or not
resource_group	text	=	The resource group which holds this resource.
sku_capacity	bigint		Current number of instances assigned to the resource.
sku_family	text		Family code of the resource SKU
sku_name	text		Name of the resource SKU
sku_size	text		Size specifier of the resource SKU
sku_tier	text		Service tier of the resource SKU
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		App Service plan status
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
target_worker_count	bigint		Scaling worker count
target_worker_size_id	bigint		Scaling worker size ID
title	text		Title of the resource.
type	text		The resource type of the app service plan
worker_tier_name	text		Target worker tier assigned to the App Service plan
zone_redundant	boolean		If true, this App Service Plan will perform availability zone balancing.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_app_service_plan