Skip to main content

vw_registries

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

Overview​

Namevw_registries
TypeView
Idazure.container_registry.vw_registries

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,
systemData as system_data,
sku as sku,
identity as identity,
JSON_EXTRACT(properties, '$.loginServer') as "login_server",
JSON_EXTRACT(properties, '$.creationDate') as "creation_date",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.adminUserEnabled') as "admin_user_enabled",
JSON_EXTRACT(properties, '$.networkRuleSet') as "network_rule_set",
JSON_EXTRACT(properties, '$.policies') as "policies",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
JSON_EXTRACT(properties, '$.dataEndpointEnabled') as "data_endpoint_enabled",
JSON_EXTRACT(properties, '$.dataEndpointHostNames') as "data_endpoint_host_names",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.networkRuleBypassOptions') as "network_rule_bypass_options",
JSON_EXTRACT(properties, '$.zoneRedundancy') as "zone_redundancy",
JSON_EXTRACT(properties, '$.anonymousPullEnabled') as "anonymous_pull_enabled",
JSON_EXTRACT(properties, '$.metadataSearch') as "metadata_search",
subscriptionId,
resourceGroupName,
registryName
FROM azure.container_registry.registries
WHERE subscriptionId = 'replace-me';