Skip to main content

vw_replication_recovery_plans

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

Overview​

Namevw_replication_recovery_plans
TypeView
Idazure.recovery_services_site_recovery.vw_replication_recovery_plans

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, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.primaryFabricId') as "primary_fabric_id",
JSON_EXTRACT(properties, '$.primaryFabricFriendlyName') as "primary_fabric_friendly_name",
JSON_EXTRACT(properties, '$.recoveryFabricId') as "recovery_fabric_id",
JSON_EXTRACT(properties, '$.recoveryFabricFriendlyName') as "recovery_fabric_friendly_name",
JSON_EXTRACT(properties, '$.failoverDeploymentModel') as "failover_deployment_model",
JSON_EXTRACT(properties, '$.replicationProviders') as "replication_providers",
JSON_EXTRACT(properties, '$.allowedOperations') as "allowed_operations",
JSON_EXTRACT(properties, '$.lastPlannedFailoverTime') as "last_planned_failover_time",
JSON_EXTRACT(properties, '$.lastUnplannedFailoverTime') as "last_unplanned_failover_time",
JSON_EXTRACT(properties, '$.lastTestFailoverTime') as "last_test_failover_time",
JSON_EXTRACT(properties, '$.currentScenario') as "current_scenario",
JSON_EXTRACT(properties, '$.currentScenarioStatus') as "current_scenario_status",
JSON_EXTRACT(properties, '$.currentScenarioStatusDescription') as "current_scenario_status_description",
JSON_EXTRACT(properties, '$.groups') as "groups",
JSON_EXTRACT(properties, '$.providerSpecificDetails') as "provider_specific_details",
subscriptionId,
resourceGroupName,
resourceName,
recoveryPlanName
FROM azure.recovery_services_site_recovery.replication_recovery_plans
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND resourceName = 'replace-me';