vw_service_endpoint_policy_definitions

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

Overview

Name	vw_service_endpoint_policy_definitions
Type	View
Id	azure.network.vw_service_endpoint_policy_definitions

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
etag as etag,
type as type,
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.service') as "service",
JSON_EXTRACT(properties, '$.serviceResources') as "service_resources",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
serviceEndpointPolicyName,
serviceEndpointPolicyDefinitionName
FROM azure.network.service_endpoint_policy_definitions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceEndpointPolicyName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
etag as etag,
type as type,
json_extract_path_text(properties, '$.description') as "description",
json_extract_path_text(properties, '$.service') as "service",
json_extract_path_text(properties, '$.serviceResources') as "service_resources",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
serviceEndpointPolicyName,
serviceEndpointPolicyDefinitionName
FROM azure.network.service_endpoint_policy_definitions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceEndpointPolicyName = 'replace-me';