turbot/azure

steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_api_managementazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_application_security_groupazure_compute_availability_setazure_compute_diskazure_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_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_cosmosdb_accountazure_cosmosdb_mongo_databaseazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_diagnostic_settingazure_express_route_circuitazure_firewallazure_key_vaultazure_key_vault_keyazure_key_vault_secretazure_kubernetes_clusterazure_locationazure_log_alertazure_log_profileazure_management_lockazure_mysql_serverazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_serverazure_providerazure_public_ipazure_resource_groupazure_role_assignmentazure_role_definitionazure_route_tableazure_security_center_auto_provisioningazure_security_center_contactazure_security_center_settingazure_security_center_subscription_pricingazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_tableazure_storage_table_serviceazure_subnetazure_subscriptionazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_app_service_environment

The Azure App Service Environment provides a fully isolated and dedicated environment for securely running App Service apps at high scale.

Examples

List of app service environments which are not healthy

select
name,
is_healthy_environment
from
azure_app_service_environment
where
not is_healthy_environment;

Virtual network info of each app service environment

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

.inspect azure_app_service_environment

Azure App Service Environment

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
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
nametextThe 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_grouptextThe 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