Skip to main content

vw_server_endpoints

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

Overview​

Namevw_server_endpoints
TypeView
Idazure.storage_sync.vw_server_endpoints

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.serverLocalPath') as "server_local_path",
JSON_EXTRACT(properties, '$.cloudTiering') as "cloud_tiering",
JSON_EXTRACT(properties, '$.volumeFreeSpacePercent') as "volume_free_space_percent",
JSON_EXTRACT(properties, '$.tierFilesOlderThanDays') as "tier_files_older_than_days",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.serverResourceId') as "server_resource_id",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.lastWorkflowId') as "last_workflow_id",
JSON_EXTRACT(properties, '$.lastOperationName') as "last_operation_name",
JSON_EXTRACT(properties, '$.syncStatus') as "sync_status",
JSON_EXTRACT(properties, '$.offlineDataTransfer') as "offline_data_transfer",
JSON_EXTRACT(properties, '$.offlineDataTransferStorageAccountResourceId') as "offline_data_transfer_storage_account_resource_id",
JSON_EXTRACT(properties, '$.offlineDataTransferStorageAccountTenantId') as "offline_data_transfer_storage_account_tenant_id",
JSON_EXTRACT(properties, '$.offlineDataTransferShareName') as "offline_data_transfer_share_name",
JSON_EXTRACT(properties, '$.cloudTieringStatus') as "cloud_tiering_status",
JSON_EXTRACT(properties, '$.recallStatus') as "recall_status",
JSON_EXTRACT(properties, '$.initialDownloadPolicy') as "initial_download_policy",
JSON_EXTRACT(properties, '$.localCacheMode') as "local_cache_mode",
JSON_EXTRACT(properties, '$.initialUploadPolicy') as "initial_upload_policy",
JSON_EXTRACT(properties, '$.serverName') as "server_name",
JSON_EXTRACT(properties, '$.serverEndpointProvisioningStatus') as "server_endpoint_provisioning_status",
subscriptionId,
resourceGroupName,
storageSyncServiceName,
syncGroupName,
serverEndpointName
FROM azure.storage_sync.server_endpoints
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND storageSyncServiceName = 'replace-me' AND syncGroupName = 'replace-me';