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_batch_accountazure_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_compute_virtual_machine_scale_setazure_container_registryazure_cosmosdb_accountazure_cosmosdb_mongo_databaseazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_data_lake_analytics_accountazure_data_lake_storeazure_diagnostic_settingazure_eventhub_namespaceazure_express_route_circuitazure_firewallazure_iothubazure_key_vaultazure_key_vault_deleted_vaultazure_key_vault_keyazure_key_vault_managed_hardware_security_moduleazure_key_vault_secretazure_kubernetes_clusterazure_lbazure_lb_backend_address_poolazure_lb_nat_ruleazure_lb_outbound_ruleazure_lb_probeazure_lb_ruleazure_locationazure_log_alertazure_log_profileazure_logic_app_workflowazure_management_lockazure_mariadb_serverazure_mssql_elasticpoolazure_mssql_managed_instanceazure_mysql_serverazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_serverazure_providerazure_public_ipazure_recovery_services_vaultazure_redis_cacheazure_resource_groupazure_resource_linkazure_role_assignmentazure_role_definitionazure_route_tableazure_search_serviceazure_security_center_auto_provisioningazure_security_center_contactazure_security_center_jit_network_access_policyazure_security_center_settingazure_security_center_subscription_pricingazure_servicebus_namespaceazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_tableazure_storage_table_serviceazure_stream_analytics_jobazure_subnetazure_subscriptionazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_app_service_function_app

A function app is the container that hosts the execution of individual functions.

Examples

List of app functions which accepts HTTP traffic

select
name,
https_only,
kind,
location
from
azure_app_service_function_app
where
not https_only;

List of all unreserved app function

select
name,
reserved,
resource_group
from
azure_app_service_function_app
where
not reserved;

Outbound IP addresses and possible outbound IP addresses info of each function app

select
name,
outbound_ip_addresses,
possible_outbound_ip_addresses
from
azure_app_service_function_app;

List of app functions where client certificate mode is disabled.

select
name,
client_cert_enabled,
kind,
location
from
azure_app_service_function_app
where
not client_cert_enabled;

Query examples

Control examples

.inspect azure_app_service_function_app

Azure App Service Function App

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
auth_settingsjsonbDescribes the Authentication/Authorization settings of an app.
client_affinity_enabledbooleanSpecify whether client affinity is enabled.
client_cert_enabledbooleanSpecify whether client certificate authentication is enabled.
configurationjsonbDescribes the configuration of an app.
default_site_hostnametextDefault hostname of the app.
enabledbooleanSpecify whether the app is enabled.
host_name_disabledbooleanSpecify whether the public hostnames of the app is disabled.
host_namesjsonbA list of hostnames associated with the app.
https_onlybooleanSpecify whether configuring a web site to accept only https requests.
idtextContains ID to identify an app service function app uniquely.
kindtextContains the kind of the resource.
nametextThe friendly name that identifies the app service function app.
outbound_ip_addressestextList of IP addresses that the app uses for outbound connections (e.g. database access).
possible_outbound_ip_addressestextList of possible IP addresses that the app uses for outbound connections (e.g. database access).
regiontextThe Azure region/location in which the resource is located.
reservedbooleanSpecify whether the app is reserved.
resource_grouptextThe resource group which holds this resource.
site_configjsonbA map of all configuration for the app
statetextCurrent state of the app.
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 function app.