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_environment - Query Azure App Service Environments using SQL

Azure App Service Environment is a fully isolated and dedicated environment for securely running App Service apps at high scale. This service is designed for application workloads that require high scale, isolation, and secure network access. It provides a fully isolated and dedicated environment for running applications of almost any scale.

Table Usage Guide

The azure_app_service_environment table provides insights into App Service Environments within Azure. As a DevOps engineer, you can explore specific details about these environments, including the number of workers, the status of the environment, and the virtual network integration. This table is useful for understanding the scale, isolation, and security of your app services, and to identify any potential issues or areas for optimization.

Examples

List of app service environments which are not healthy

Uncover the details of Azure App Service environments that are currently not in a healthy state. This can be useful for identifying potential issues that may be affecting the performance or availability of your applications.

select
name,
is_healthy_environment
from
azure_app_service_environment
where
not is_healthy_environment;
select
name,
is_healthy_environment
from
azure_app_service_environment
where
not is_healthy_environment;

Virtual network info of each app service environment

Explore the virtual network configurations of each app service environment to gain insights into the internal load balancing mode and understand the network segregation. This is useful in assessing the security and isolation measures within your Azure App Service Environment.

select
name,
vnet_name,
vnet_subnet_name,
vnet_resource_group_name,
internal_load_balancing_mode
from
azure_app_service_environment;
select
name,
vnet_name,
vnet_subnet_name,
vnet_resource_group_name,
internal_load_balancing_mode
from
azure_app_service_environment;

List cluster settings details

Explore the configuration details of your Azure App Service Environment to understand the specifics of your cluster settings. This can aid in managing your resources more effectively and troubleshooting potential issues.

select
name,
id,
settings ->> 'name' as settings_name,
settings ->> 'value' as settings_value
from
azure_app_service_environment,
jsonb_array_elements(cluster_settings) as settings;
select
name,
id,
json_extract(settings.value, '$.name') as settings_name,
json_extract(settings.value, '$.value') as settings_value
from
azure_app_service_environment,
json_each(cluster_settings) as settings;

Control examples

Schema for azure_app_service_environment

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
cluster_settingsjsonbCustom settings for changing the behavior of the App Service Environment.
default_front_end_scale_factorbigintDefault Scale Factor for FrontEnds
dynamic_cache_enabledbooleanIndicates whether the dynamic cache is enabled or not
front_end_scale_factorbigintScale factor for front-ends
has_linux_workersbooleanIndicates whether an ASE has linux workers or not
idtextContains ID to identify an app service environment uniquely
internal_load_balancing_modetextSpecifies which endpoints to serve internally in the Virtual Network for the App Service Environment
is_healthy_environmentbooleanIndicates whether the App Service Environment is healthy
kindtextContains the kind of the resource
nametext=The friendly name that identifies the app service environment
provisioning_statetextProvisioning state of the App Service Environment
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
statustextCurrent status of the App Service Environment
subscription_idtextThe Azure Subscription ID in which the resource is located.
suspendedbooleanIndicates whether the App Service Environment is suspended or not
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe resource type of the app service environment
vnet_nametextName of the Virtual Network for the App Service Environment
vnet_resource_group_nametextName of the resource group where the virtual network is created
vnet_subnet_nametextName of the subnet of the virtual network

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_environment