steampipe plugin install azure

Table: azure_compute_availability_set - Query Azure Compute Availability Sets using SQL

Azure Compute Availability Sets are a high-availability feature for providing redundant compute resources in Azure. They enable you to ensure that your application is available during planned and unplanned maintenance. Availability Sets are a strategy for achieving high availability and fault tolerance in Azure by ensuring that VM resources are located across multiple isolated hardware nodes in a cluster.

Table Usage Guide

The azure_compute_availability_set table provides insights into the availability sets within Azure Compute. As a system administrator, explore availability set-specific details through this table, including fault domains, update domains, and associated metadata. Use it to uncover information about availability sets, such as those with high fault tolerance and the verification of update policies.

Examples

Basic info

Analyze the settings to understand the count of fault domains and update domains within your Azure Compute availability sets across different regions. This is beneficial for managing and optimizing your cloud resources, ensuring balanced workloads and high availability.

select
name,
platform_fault_domain_count,
platform_update_domain_count,
region
from
azure_compute_availability_set;
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

Determine the areas in which Azure availability sets are not utilizing the managed disks configuration. This can be useful in identifying potential opportunities for optimization and cost reduction.

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

List of availability sets without application tag key

Explore which Azure Compute availability sets are missing an 'application' tag. This is useful for identifying areas in your infrastructure that may lack important metadata, potentially impacting resource management and organization.

select
name,
tags
from
azure_compute_availability_set
where
not tags :: JSONB ? 'application';
select
name,
tags
from
azure_compute_availability_set
where
json_extract(tags, '$.application') is null;

Schema for azure_compute_availability_set

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
idtextThe unique id identifying the resource in subscription
nametext=The 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_grouptext=The 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
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statusjsonbThe resource status information
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The 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

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_compute_availability_set