steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_alert_managementazure_api_managementazure_api_management_backendazure_app_configurationazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_app_service_web_app_slotazure_application_gatewayazure_application_insightazure_application_security_groupazure_automation_accountazure_automation_variableazure_bastion_hostazure_batch_accountazure_cognitive_accountazure_compute_availability_setazure_compute_diskazure_compute_disk_accessazure_compute_disk_encryption_setazure_compute_disk_metric_read_opsazure_compute_disk_metric_read_ops_dailyazure_compute_disk_metric_read_ops_hourlyazure_compute_disk_metric_write_opsazure_compute_disk_metric_write_ops_dailyazure_compute_disk_metric_write_ops_hourlyazure_compute_imageazure_compute_resource_skuazure_compute_snapshotazure_compute_ssh_keyazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_compute_virtual_machine_scale_setazure_compute_virtual_machine_scale_set_network_interfaceazure_compute_virtual_machine_scale_set_vmazure_consumption_usageazure_container_groupazure_container_registryazure_cosmosdb_accountazure_cosmosdb_mongo_collectionazure_cosmosdb_mongo_databaseazure_cosmosdb_restorable_database_accountazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_data_lake_analytics_accountazure_data_lake_storeazure_databox_edge_deviceazure_databricks_workspaceazure_diagnostic_settingazure_dns_zoneazure_eventgrid_domainazure_eventgrid_topicazure_eventhub_namespaceazure_express_route_circuitazure_firewallazure_firewall_policyazure_frontdoorazure_hdinsight_clusterazure_healthcare_serviceazure_hpc_cacheazure_hybrid_compute_machineazure_hybrid_kubernetes_connected_clusterazure_iothubazure_iothub_dpsazure_key_vaultazure_key_vault_deleted_vaultazure_key_vault_keyazure_key_vault_key_versionazure_key_vault_managed_hardware_security_moduleazure_key_vault_secretazure_kubernetes_clusterazure_kubernetes_service_versionazure_kusto_clusterazure_lbazure_lb_backend_address_poolazure_lb_nat_ruleazure_lb_outbound_ruleazure_lb_probeazure_lb_ruleazure_locationazure_log_alertazure_log_profileazure_logic_app_workflowazure_machine_learning_workspaceazure_management_groupazure_management_lockazure_mariadb_serverazure_monitor_activity_log_eventazure_monitor_log_profileazure_mssql_elasticpoolazure_mssql_managed_instanceazure_mssql_virtual_machineazure_mysql_flexible_serverazure_mysql_serverazure_nat_gatewayazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_flexible_serverazure_postgresql_serverazure_private_dns_zoneazure_providerazure_public_ipazure_recovery_services_backup_jobazure_recovery_services_vaultazure_redis_cacheazure_resource_groupazure_resource_linkazure_role_assignmentazure_role_definitionazure_route_tableazure_search_serviceazure_security_center_auto_provisioningazure_security_center_automationazure_security_center_contactazure_security_center_jit_network_access_policyazure_security_center_settingazure_security_center_sub_assessmentazure_security_center_subscription_pricingazure_service_fabric_clusterazure_servicebus_namespaceazure_signalr_serviceazure_spring_cloud_serviceazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_share_fileazure_storage_syncazure_storage_tableazure_storage_table_serviceazure_stream_analytics_jobazure_subnetazure_subscriptionazure_synapse_workspaceazure_tenantazure_virtual_networkazure_virtual_network_gateway

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
appsjsonbSite a web app, a mobile app backend, or an API app.
cloud_environmenttextThe Azure Cloud Environment.
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
nametext=The 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_grouptext=The 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

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