vw_dicom_services
Creates, updates, deletes, gets or lists a vw_dicom_services
resource.
Overview
Name | vw_dicom_services |
Type | View |
Id | azure_extras.healthcare.vw_dicom_services |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
identity as identity,
systemData as system_data,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.authenticationConfiguration') as "authentication_configuration",
JSON_EXTRACT(properties, '$.corsConfiguration') as "cors_configuration",
JSON_EXTRACT(properties, '$.serviceUrl') as "service_url",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.eventState') as "event_state",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
JSON_EXTRACT(properties, '$.storageConfiguration') as "storage_configuration",
JSON_EXTRACT(properties, '$.enableDataPartitions') as "enable_data_partitions",
subscriptionId,
resourceGroupName,
workspaceName,
dicomServiceName
FROM azure_extras.healthcare.dicom_services
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';
SELECT
identity as identity,
systemData as system_data,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.authenticationConfiguration') as "authentication_configuration",
json_extract_path_text(properties, '$.corsConfiguration') as "cors_configuration",
json_extract_path_text(properties, '$.serviceUrl') as "service_url",
json_extract_path_text(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
json_extract_path_text(properties, '$.publicNetworkAccess') as "public_network_access",
json_extract_path_text(properties, '$.eventState') as "event_state",
json_extract_path_text(properties, '$.encryption') as "encryption",
json_extract_path_text(properties, '$.storageConfiguration') as "storage_configuration",
json_extract_path_text(properties, '$.enableDataPartitions') as "enable_data_partitions",
subscriptionId,
resourceGroupName,
workspaceName,
dicomServiceName
FROM azure_extras.healthcare.dicom_services
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND workspaceName = 'replace-me';