vw_disks

Creates, updates, deletes, gets or lists a vw_disks resource.

Overview

Name	vw_disks
Type	View
Id	azure_stack.compute_admin.vw_disks

Fields

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
JSON_EXTRACT(properties, '$.diskId') as "disk_id",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.sharePath') as "share_path",
JSON_EXTRACT(properties, '$.actualSizeGB') as "actual_size_gb",
JSON_EXTRACT(properties, '$.provisionSizeGB') as "provision_size_gb",
JSON_EXTRACT(properties, '$.managedBy') as "managed_by",
JSON_EXTRACT(properties, '$.userResourceId') as "user_resource_id",
JSON_EXTRACT(properties, '$.diskType') as "disk_type",
JSON_EXTRACT(properties, '$.diskSku') as "disk_sku",
JSON_EXTRACT(properties, '$.creationSourceUri') as "creation_source_uri",
JSON_EXTRACT(properties, '$.creationOption') as "creation_option",
JSON_EXTRACT(properties, '$.exclusiveAllocatedSize') as "exclusive_allocated_size",
subscriptionId,
location,
diskId
FROM azure_stack.compute_admin.disks
WHERE subscriptionId = 'replace-me' AND location = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
json_extract_path_text(properties, '$.diskId') as "disk_id",
json_extract_path_text(properties, '$.status') as "status",
json_extract_path_text(properties, '$.sharePath') as "share_path",
json_extract_path_text(properties, '$.actualSizeGB') as "actual_size_gb",
json_extract_path_text(properties, '$.provisionSizeGB') as "provision_size_gb",
json_extract_path_text(properties, '$.managedBy') as "managed_by",
json_extract_path_text(properties, '$.userResourceId') as "user_resource_id",
json_extract_path_text(properties, '$.diskType') as "disk_type",
json_extract_path_text(properties, '$.diskSku') as "disk_sku",
json_extract_path_text(properties, '$.creationSourceUri') as "creation_source_uri",
json_extract_path_text(properties, '$.creationOption') as "creation_option",
json_extract_path_text(properties, '$.exclusiveAllocatedSize') as "exclusive_allocated_size",
subscriptionId,
location,
diskId
FROM azure_stack.compute_admin.disks
WHERE subscriptionId = 'replace-me' AND location = 'replace-me';