turbot/azure

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

Table: azure_compute_snapshot

A snapshot is a full, read-only copy of a virtual hard drive (VHD).

Examples

Disk info of each snapshot

select
name,
split_part(disk_access_id, '/', 8) as disk_name,
disk_encryption_set_id,
disk_size_gb,
region
from
azure_compute_snapshot;

List of snapshots which are publicly accessible

select
name,
network_access_policy
from
azure_compute_snapshot
where
network_access_policy = 'AllowAll';

List of all incremental type snapshots

select
name,
incremental
from
azure_compute_snapshot
where
incremental;

.inspect azure_compute_snapshot

Azure Compute Snapshot

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
create_optiontextSpecifies the possible sources of a disk's creation
disk_access_idtextARM id of the DiskAccess resource for using private endpoints on disks
disk_encryption_set_idtextResourceId of the disk encryption set to use for enabling encryption at rest
disk_size_bytesbigintThe size of the disk in bytes
disk_size_gbbigintThe size of the disk to create
encryption_setting_collection_enabledbooleanSpecifies whether the encryption is enables, or not
encryption_setting_versiontextDescribes what type of encryption is used for the disks
encryption_settingsjsonbA list of encryption settings, one for each disk volume
encryption_typetextThe type of the encryption
gallery_image_reference_idtextA relative uri containing either a Platform Image Repository or user image reference
gallery_reference_lunbigintSpecifies the index that indicates which of the data disks in the image to use
hyperv_generationtextSpecifies the hypervisor generation of the Virtual Machine
idtextThe unique id identifying the resource in subscription
image_reference_idtextA relative uri containing either a Platform Image Repository or user image reference
image_reference_lunbigintSpecifies the index that indicates which of the data disks in the image to use
incrementalbooleanSpecifies whether a snapshot is incremental, or not
nametextThe friendly name that identifies the snapshot
network_access_policytextContains the type of access
os_typetextContains the type of operating system
provisioning_statetextThe disk provisioning state
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
sku_nametextThe snapshot sku name
sku_tiertextThe sku tier
source_resource_idtextARM id of the source snapshot or disk
source_unique_idtextAn unique id identifying the source of this resource
source_uritextAn URI of a blob to be imported into a managed disk
storage_account_idtextThe Azure Resource Manager identifier of the storage account containing the blob to import as a disk
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
time_createdtimestamp without time zoneThe time when the snapshot was created
titletextTitle of the resource.
typetextThe type of the resource in Azure
unique_idtextAn unique Guid identifying the resource
upload_size_bytesbigintThe size of the contents of the upload including the VHD footer
virtual_machinesjsonbA list of references to all virtual machines in the availability set