steampipe plugin install azuresteampipe plugin install azure

Table: azure_compute_virtual_machine_scale_set - Query Azure Compute Virtual Machine Scale Sets using SQL

Azure Compute Virtual Machine Scale Sets are a service within Microsoft Azure that allows you to create and manage a group of identical, load balanced VMs. They enable you to centrally manage, configure, and update a large number of VMs in minutes to provide highly available applications. The scale set adjusts the number of VMs in response to demand or a defined schedule.

Table Usage Guide

The azure_compute_virtual_machine_scale_set table provides insights into Azure Compute Virtual Machine Scale Sets within Microsoft Azure. As a system administrator or DevOps engineer, explore scale set-specific details through this table, including configuration, capacity, and status. Utilize it to uncover information about scale sets, such as their current capacity, configuration details, and overall status, aiding in efficient management and monitoring of your virtual machine resources.

Examples

Basic info

Explore the configuration of your virtual machine scale sets in Azure to identify their associated regions and resource groups. This can help you manage and organize your resources more efficiently.

select
  name,
  id,
  identity,
  region,
  resource_group
from
  azure_compute_virtual_machine_scale_set;

select
  name,
  id,
  identity,
  region,
  resource_group
from
  azure_compute_virtual_machine_scale_set;

List Standard tier virtual machine scale set

Determine the areas in which standard-tier virtual machine scale sets are being used within your Azure Compute environment. This query helps to understand resource allocation and cost management.

select
  name,
  id,
  sku_name,
  sku_tier
from
  azure_compute_virtual_machine_scale_set
where
  sku_tier = 'Standard';

select
  name,
  id,
  sku_name,
  sku_tier
from
  azure_compute_virtual_machine_scale_set
where
  sku_tier = 'Standard';

Query examples

Control examples

Schema for azure_compute_virtual_machine_scale_set

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
cloud_environment	text		The Azure Cloud Environment.
do_not_run_extensions_on_overprovisioned_vms	boolean		When Overprovision is enabled, extensions are launched only on the requested number of VMs which are finally kept.
extensions	jsonb		Specifies the details of VM Scale Set Extensions.
id	text		The unique id identifying the resource in subscription.
identity	jsonb		The identity of the virtual machine scale set, if configured.
location	text		The location of the resource.
name	text	=	Name of the scale set.
overprovision	boolean		Specifies whether the Virtual Machine Scale Set should be overprovisioned.
plan	jsonb		Specifies information about the marketplace image used to create the virtual machine.
platform_fault_domain_count	bigint		Fault Domain count for each placement group.
provisioning_state	text		The provisioning state.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
scale_in_policy	jsonb		Specifies the scale-in policy that decides which virtual machines are chosen for removal when a Virtual Machine Scale Set is scaled-in.
single_placement_group	boolean		When true this limits the scale set to a single placement group, of max size 100 virtual machines.
sku_capacity	bigint		Specifies the tier of virtual machines in a scale set.
sku_name	text		The sku name.
sku_tier	text		Specifies the tier of virtual machines in a scale set.
subscription_id	text		The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		Resource tags.
title	text		Title of the resource.
type	text		The type of the resource in Azure.
unique_id	text		Specifies the ID which uniquely identifies a Virtual Machine Scale Set.
upgrade_policy	jsonb		The upgrade policy for the scale set.
virtual_machine_diagnostics_profile	jsonb		Specifies the boot diagnostic settings state.
virtual_machine_extension_profile	jsonb		Specifies a collection of settings for extensions installed on virtual machines in the scale set.
virtual_machine_network_profile	jsonb		Specifies properties of the network interfaces of the virtual machines in the scale set.
virtual_machine_os_profile	jsonb		Specifies the operating system settings for the virtual machines in the scale set.
virtual_machine_security_profile	jsonb		Specifies the Security related profile settings for the virtual machines in the scale set.
virtual_machine_storage_profile	jsonb		Specifies the storage settings for the virtual machine disks.
zones	jsonb		The Logical zone list for scale 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_virtual_machine_scale_set