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_compute_availability_set

An Availability Set is a logical grouping capability for isolating VM resources from each other when they're deployed.

Examples

Availability set basic info

select
name,
platform_fault_domain_count,
platform_update_domain_count,
region
from
azure_compute_availability_set;

List of availability sets which does not use managed disks configuration

select
name,
sku_name
from
azure_compute_availability_set
where
sku_name = 'Classic';

List of availability sets without application tag key

select
name,
tags
from
azure_compute_availability_set
where
not tags :: JSONB ? 'application';

.inspect azure_compute_availability_set

Azure Compute Availability Set

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
idtextThe unique id identifying the resource in subscription
nametextThe friendly name that identifies the availability set
platform_fault_domain_countbigintContains the fault domain count
platform_update_domain_countbigintContains the update domain count
proximity_placement_group_idtextSpecifies information about the proximity placement group that the availability set should be assigned to
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
sku_capacitybigintSpecifies the number of virtual machines in the scale set
sku_nametextThe availability sets sku name
sku_tiertextSpecifies the tier of virtual machines in a scale set
statusjsonbThe resource status information
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe type of the resource in Azure
virtual_machinesjsonbA list of references to all virtual machines in the availability set