Skip to main content

vw_replication_protection_container_mappings

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

Overview​

Namevw_replication_protection_container_mappings
TypeView
Idazure.recovery_services_site_recovery.vw_replication_protection_container_mappings

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,
JSON_EXTRACT(properties, '$.targetProtectionContainerId') as "target_protection_container_id",
JSON_EXTRACT(properties, '$.targetProtectionContainerFriendlyName') as "target_protection_container_friendly_name",
JSON_EXTRACT(properties, '$.providerSpecificDetails') as "provider_specific_details",
JSON_EXTRACT(properties, '$.health') as "health",
JSON_EXTRACT(properties, '$.healthErrorDetails') as "health_error_details",
JSON_EXTRACT(properties, '$.policyId') as "policy_id",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.sourceProtectionContainerFriendlyName') as "source_protection_container_friendly_name",
JSON_EXTRACT(properties, '$.sourceFabricFriendlyName') as "source_fabric_friendly_name",
JSON_EXTRACT(properties, '$.targetFabricFriendlyName') as "target_fabric_friendly_name",
JSON_EXTRACT(properties, '$.policyFriendlyName') as "policy_friendly_name",
subscriptionId,
resourceGroupName,
resourceName,
fabricName,
protectionContainerName,
mappingName
FROM azure.recovery_services_site_recovery.replication_protection_container_mappings
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND resourceName = 'replace-me';