Table: azure_compute_disk - Query Azure Compute Disks using SQL

Azure Compute Disk is a resource within Microsoft Azure that allows you to create and manage disks for your virtual machines. These disks can be used as system disks or data disks and come in different types, including standard HDD, standard SSD, and premium SSD. Azure Compute Disk also supports disk encryption for enhanced security.

Table Usage Guide

The azure_compute_disk table provides insights into the disks used in Azure Compute. As a system administrator or developer, you can explore disk-specific details through this table, including the type, size, location, and encryption settings of each disk. Utilize it to manage disk resources effectively, ensuring optimal allocation and enhanced security.

Examples

List of all premium tier compute disks

Determine the areas in which premium tier compute disks are being utilized across your Azure environment. This can help in resource management and cost optimization by identifying areas of high-end usage.

select
  name,
  sku_name,
  sku_tier
from
  azure_compute_disk
where
  sku_tier = 'Premium';

select
  name,
  sku_name,
  sku_tier
from
  azure_compute_disk
where
  sku_tier = 'Premium';

List of unattached disks

Discover the segments that consist of unused storage resources within your Azure infrastructure. This can aid in optimizing resource allocation and reducing unnecessary costs.

select
  name,
  disk_state
from
  azure_compute_disk
where
  disk_state = 'Unattached';

select
  name,
  disk_state
from
  azure_compute_disk
where
  disk_state = 'Unattached';

Size and performance info of each disk

Gain insights into the performance and size of each disk in your Azure Compute service. This helps in optimizing resource allocation and identifying potential performance bottlenecks.

select
  name,
  disk_size_gb as disk_size,
  disk_iops_read_only as disk_iops_read_only,
  disk_iops_read_write as provision_iops,
  disk_iops_mbps_read_write as bandwidth,
  disk_iops_mbps_read_only as disk_mbps_read_write
from
  azure_compute_disk;

select
  name,
  disk_size_gb as disk_size,
  disk_iops_read_only as disk_iops_read_only,
  disk_iops_read_write as provision_iops,
  disk_iops_mbps_read_write as bandwidth,
  disk_iops_mbps_read_only as disk_mbps_read_write
from
  azure_compute_disk;

List of compute disks which are not available in multiple az

Determine the areas in which Azure Compute Disks are not available across multiple availability zones. This is useful for identifying potential vulnerabilities in your system's redundancy and disaster recovery capabilities.

select
  name,
  az,
  region
from
  azure_compute_disk
  cross join jsonb_array_elements(zones) az
where
  zones is not null;

select
  name,
  az.value as az,
  region
from
  azure_compute_disk,
  json_each(zones) az
where
  zones is not null;

List of compute disks which are not encrypted with customer key

Discover the segments that utilize compute disks not encrypted with a customer key, enabling you to identify potential security risks and take necessary actions to enhance data protection.

select
  name,
  encryption_type
from
  azure_compute_disk
where
  encryption_type <> 'EncryptionAtRestWithCustomerKey';

select
  name,
  encryption_type
from
  azure_compute_disk
where
  encryption_type != 'EncryptionAtRestWithCustomerKey';

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_disk