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

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.
id	text		The unique id identifying the resource in subscription
name	text	=	The friendly name that identifies the availability set
platform_fault_domain_count	bigint		Contains the fault domain count
platform_update_domain_count	bigint		Contains the update domain count
proximity_placement_group_id	text		Specifies information about the proximity placement group that the availability set should be assigned to
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
sku_capacity	bigint		Specifies the number of virtual machines in the scale set
sku_name	text		The availability sets sku name
sku_tier	text		Specifies the tier of virtual machines in a scale set
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	jsonb		The resource status information
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The type of the resource in Azure
virtual_machines	jsonb		A 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