vw_volume_containers

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

Overview

Name	vw_volume_containers
Type	View
Id	azure_extras.storsimple_8000_series.vw_volume_containers

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,
kind as kind,
JSON_EXTRACT(properties, '$.encryptionKey') as "encryption_key",
JSON_EXTRACT(properties, '$.encryptionStatus') as "encryption_status",
JSON_EXTRACT(properties, '$.volumeCount') as "volume_count",
JSON_EXTRACT(properties, '$.storageAccountCredentialId') as "storage_account_credential_id",
JSON_EXTRACT(properties, '$.ownerShipStatus') as "owner_ship_status",
JSON_EXTRACT(properties, '$.bandWidthRateInMbps') as "band_width_rate_in_mbps",
JSON_EXTRACT(properties, '$.bandwidthSettingId') as "bandwidth_setting_id",
JSON_EXTRACT(properties, '$.totalCloudStorageUsageInBytes') as "total_cloud_storage_usage_in_bytes",
subscriptionId,
resourceGroupName,
managerName,
deviceName,
volumeContainerName
FROM azure_extras.storsimple_8000_series.volume_containers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managerName = 'replace-me' AND deviceName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
kind as kind,
json_extract_path_text(properties, '$.encryptionKey') as "encryption_key",
json_extract_path_text(properties, '$.encryptionStatus') as "encryption_status",
json_extract_path_text(properties, '$.volumeCount') as "volume_count",
json_extract_path_text(properties, '$.storageAccountCredentialId') as "storage_account_credential_id",
json_extract_path_text(properties, '$.ownerShipStatus') as "owner_ship_status",
json_extract_path_text(properties, '$.bandWidthRateInMbps') as "band_width_rate_in_mbps",
json_extract_path_text(properties, '$.bandwidthSettingId') as "bandwidth_setting_id",
json_extract_path_text(properties, '$.totalCloudStorageUsageInBytes') as "total_cloud_storage_usage_in_bytes",
subscriptionId,
resourceGroupName,
managerName,
deviceName,
volumeContainerName
FROM azure_extras.storsimple_8000_series.volume_containers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managerName = 'replace-me' AND deviceName = 'replace-me';