Skip to main content

vw_labs

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

Overview​

Namevw_labs
TypeView
Idazure.dev_test_labs.vw_labs

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
JSON_EXTRACT(properties, '$.defaultStorageAccount') as "default_storage_account",
JSON_EXTRACT(properties, '$.defaultPremiumStorageAccount') as "default_premium_storage_account",
JSON_EXTRACT(properties, '$.artifactsStorageAccount') as "artifacts_storage_account",
JSON_EXTRACT(properties, '$.premiumDataDiskStorageAccount') as "premium_data_disk_storage_account",
JSON_EXTRACT(properties, '$.vaultName') as "vault_name",
JSON_EXTRACT(properties, '$.labStorageType') as "lab_storage_type",
JSON_EXTRACT(properties, '$.mandatoryArtifactsResourceIdsLinux') as "mandatory_artifacts_resource_ids_linux",
JSON_EXTRACT(properties, '$.mandatoryArtifactsResourceIdsWindows') as "mandatory_artifacts_resource_ids_windows",
JSON_EXTRACT(properties, '$.createdDate') as "created_date",
JSON_EXTRACT(properties, '$.premiumDataDisks') as "premium_data_disks",
JSON_EXTRACT(properties, '$.environmentPermission') as "environment_permission",
JSON_EXTRACT(properties, '$.announcement') as "announcement",
JSON_EXTRACT(properties, '$.support') as "support",
JSON_EXTRACT(properties, '$.vmCreationResourceGroup') as "vm_creation_resource_group",
JSON_EXTRACT(properties, '$.publicIpId') as "public_ip_id",
JSON_EXTRACT(properties, '$.loadBalancerId') as "load_balancer_id",
JSON_EXTRACT(properties, '$.networkSecurityGroupId') as "network_security_group_id",
JSON_EXTRACT(properties, '$.extendedProperties') as "extended_properties",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.uniqueIdentifier') as "unique_identifier",
subscriptionId,
resourceGroupName,
name
FROM azure.dev_test_labs.labs
WHERE subscriptionId = 'replace-me';