Skip to main content

vw_pools

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

Overview​

Namevw_pools
TypeView
Idazure.dev_center.vw_pools

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.devBoxDefinitionType') as "dev_box_definition_type",
JSON_EXTRACT(properties, '$.devBoxDefinitionName') as "dev_box_definition_name",
JSON_EXTRACT(properties, '$.devBoxDefinition') as "dev_box_definition",
JSON_EXTRACT(properties, '$.networkConnectionName') as "network_connection_name",
JSON_EXTRACT(properties, '$.licenseType') as "license_type",
JSON_EXTRACT(properties, '$.localAdministrator') as "local_administrator",
JSON_EXTRACT(properties, '$.stopOnDisconnect') as "stop_on_disconnect",
JSON_EXTRACT(properties, '$.singleSignOnStatus') as "single_sign_on_status",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.virtualNetworkType') as "virtual_network_type",
JSON_EXTRACT(properties, '$.managedVirtualNetworkRegions') as "managed_virtual_network_regions",
JSON_EXTRACT(properties, '$.healthStatus') as "health_status",
JSON_EXTRACT(properties, '$.healthStatusDetails') as "health_status_details",
JSON_EXTRACT(properties, '$.devBoxCount') as "dev_box_count",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
projectName,
poolName
FROM azure.dev_center.pools
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND projectName = 'replace-me';