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

App Service Environment should enable internal encryption

Schema for azure_app_service_environment

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.
cloud_environment	text		The Azure Cloud Environment.
cluster_settings	jsonb		Custom settings for changing the behavior of the App Service Environment.
default_front_end_scale_factor	bigint		Default Scale Factor for FrontEnds
dynamic_cache_enabled	boolean		Indicates whether the dynamic cache is enabled or not
front_end_scale_factor	bigint		Scale factor for front-ends
has_linux_workers	boolean		Indicates whether an ASE has linux workers or not
id	text		Contains ID to identify an app service environment uniquely
internal_load_balancing_mode	text		Specifies which endpoints to serve internally in the Virtual Network for the App Service Environment
is_healthy_environment	boolean		Indicates whether the App Service Environment is healthy
kind	text		Contains the kind of the resource
name	text	=	The friendly name that identifies the app service environment
provisioning_state	text		Provisioning state of the App Service Environment
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Current status of the App Service Environment
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
suspended	boolean		Indicates whether the App Service Environment is suspended or not
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The resource type of the app service environment
vnet_name	text		Name of the Virtual Network for the App Service Environment
vnet_resource_group_name	text		Name of the resource group where the virtual network is created
vnet_subnet_name	text		Name 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