turbot/azure

steampipe plugin install azuresteampipe plugin install azure
On This Page
Get Involved

Table: azure_compute_resource_sku

Types of sku available for azure compute resources.

Examples

Compute resources sku info

select
name,
tier,
size,
family,
kind
from
azure_compute_resource_sku;

Azure compute resources and their capacity

select
name,
default_capacity,
maximum_capacity,
minimum_capacity
from
azure_compute_resource_sku;

List of all premium type disks and location

select
name,
resource_type tier,
l as location
from
azure_compute_resource_sku,
jsonb_array_elements_text(locations) as l
where
resource_type = 'disks'
and tier = 'Premium';

.inspect azure_compute_resource_sku

Azure Compute Resource SKU

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
api_versionsjsonbThe api versions that support this SKU
capabilitiesjsonbA name value pair to describe the capability
costsjsonbA list of metadata for retrieving price info
default_capacitybigintContains the default capacity
familytextThe Family of this particular SKU
kindtextThe Kind of resources that are supported in this SKU
location_infojsonbA list of locations and availability zones in those locations where the SKU is available
locationsjsonbThe set of locations that the SKU is available
maximum_capacitybigintThe maximum capacity that can be set
minimum_capacitybigintThe minimum capacity that can be set
nametextThe name of SKU
resource_typetextThe type of resource the SKU applies to
restrictionsjsonbThe restrictions because of which SKU cannot be used
scale_typetextThe scale type applicable to the sku
sizetextThe Size of the SKU
tiertextSpecifies the tier of virtual machines in a scale set
titletextTitle of the resource.