Skip to main content

vw_services

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

Overview​

Namevw_services
TypeView
Idazure.search.vw_services

Fields​

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

SQL Definition​

SELECT
location as location,
sku as sku,
identity as identity,
tags as tags,
JSON_EXTRACT(properties, '$.replicaCount') as "replica_count",
JSON_EXTRACT(properties, '$.partitionCount') as "partition_count",
JSON_EXTRACT(properties, '$.hostingMode') as "hosting_mode",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.statusDetails') as "status_details",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.networkRuleSet') as "network_rule_set",
JSON_EXTRACT(properties, '$.disabledDataExfiltrationOptions') as "disabled_data_exfiltration_options",
JSON_EXTRACT(properties, '$.encryptionWithCmk') as "encryption_with_cmk",
JSON_EXTRACT(properties, '$.disableLocalAuth') as "disable_local_auth",
JSON_EXTRACT(properties, '$.authOptions') as "auth_options",
JSON_EXTRACT(properties, '$.semanticSearch') as "semantic_search",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.sharedPrivateLinkResources') as "shared_private_link_resources",
JSON_EXTRACT(properties, '$.eTag') as "e_tag",
subscriptionId,
resourceGroupName,
searchServiceName
FROM azure.search.services
WHERE subscriptionId = 'replace-me';