turbot/azure

steampipe plugin install azuresteampipe plugin install azure
On This Page
Get Involved

Table: azure_app_service_plan

An App Service plan 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.

Examples

App service plan SKU info

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

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

List of App service plan that owns spot instances

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

.inspect azure_app_service_plan

Azure App Service Plan

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
hyper_vbooleanSpecify whether resource is Hyper-V container app service plan
idtextContains ID to identify an app service plan uniquely
is_spotbooleanSpecify whether this App Service Plan owns spot instances, or not
is_xenonbooleanSpecify whether resource is Hyper-V container app service plan
kindtextContains the kind of the resource
maximum_elastic_worker_countbigintMaximum number of total workers allowed for this ElasticScaleEnabled App Service Plan
maximum_number_of_workersbigintMaximum number of instances that can be assigned to this App Service plan
nametextThe friendly name that identifies the app service plan
per_site_scalingbooleanSpecify whether apps assigned to this App Service plan can be scaled independently
provisioning_statetextProvisioning state of the App Service Environment
regiontextThe Azure region/location in which the resource is located.
reservedbooleanSpecify whether the resource is Linux app service plan, or not
resource_grouptextThe resource group which holds this resource.
sku_capacitybigintCurrent number of instances assigned to the resource.
sku_familytextFamily code of the resource SKU
sku_nametextName of the resource SKU
sku_sizetextSize specifier of the resource SKU
sku_tiertextService tier of the resource SKU
statustextApp Service plan status
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe resource type of the app service plan