turbot/azure

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

Table: azure_compute_image

Compute Engine offers many preconfigured public images that have compatible Linux or Windows operating systems. Compute Engine uses selected image to create a persistent boot disk for each instance.

Examples

Basic compute image info

select
name,
type,
location,
hyper_v_generation,
split_part(source_virtual_machine_id, '/', 9) as source_virtual_machine
from
azure_compute_image;

Storage profile's OS disk info of each compute image

select
name,
storage_profile_os_disk_size_gb,
storage_profile_os_disk_snapshot_id,
storage_profile_os_disk_storage_account_type,
storage_profile_os_disk_state,
storage_profile_os_disk_type
from
azure_compute_image;

List of compute images where disk storage type is Premium_LRS

select
name,
split_part(disk -> 'managedDisk' ->> 'id', '/', 9) as disk_name,
disk ->> 'storageAccountType' as storage_account_type,
disk ->> 'diskSizeGB' as disk_size_gb,
disk ->> 'caching' as caching
from
azure_compute_image
cross join jsonb_array_elements(storage_profile_data_disks) as disk
where
disk ->> 'storageAccountType' = 'Premium_LRS';

List of compute images which do not have owner or app_id tag key

select
id,
name
from
azure_compute_image
where
tags -> 'owner' is null
or tags -> 'app_id' is null;

.inspect azure_compute_image

Azure Compute Image

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
hyper_v_generationtextGets the HyperVGenerationType of the VirtualMachine created from the image
idtextContains ID to identify a image uniquely
nametextThe friendly name that identifies the image
provisioning_statetextThe provisioning state of the image resource
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
source_virtual_machine_idtextContains the id of the virtual machine
storage_profile_data_disksjsonbA list of parameters that are used to add a data disk to a virtual machine
storage_profile_os_disk_blob_uritextContains uri of the virtual hard disk
storage_profile_os_disk_cachingtextSpecifies the caching requirements
storage_profile_os_disk_encryption_settextSpecifies the customer managed disk encryption set resource id for the managed image disk
storage_profile_os_disk_managed_disk_idtextContains the id of the managed disk
storage_profile_os_disk_size_gbbigintSpecifies the size of empty data disks in gigabytes
storage_profile_os_disk_snapshot_idtextContains the id of the snapshot
storage_profile_os_disk_statetextContains state of the OS
storage_profile_os_disk_storage_account_typetextSpecifies the storage account type for the managed disk
storage_profile_os_disk_typetextSpecifies the type of the OS that is included in the disk if creating a VM from a custom image
storage_profile_zone_resilientbooleanSpecifies whether an image is zone resilient or not
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextType of the resource