Skip to main content

vw_replication_recovery_services_providers

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

Overview​

Namevw_replication_recovery_services_providers
TypeView
Idazure.recovery_services_site_recovery.vw_replication_recovery_services_providers

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, '$.fabricType') as "fabric_type",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.providerVersion') as "provider_version",
JSON_EXTRACT(properties, '$.serverVersion') as "server_version",
JSON_EXTRACT(properties, '$.providerVersionState') as "provider_version_state",
JSON_EXTRACT(properties, '$.providerVersionExpiryDate') as "provider_version_expiry_date",
JSON_EXTRACT(properties, '$.fabricFriendlyName') as "fabric_friendly_name",
JSON_EXTRACT(properties, '$.lastHeartBeat') as "last_heart_beat",
JSON_EXTRACT(properties, '$.connectionStatus') as "connection_status",
JSON_EXTRACT(properties, '$.protectedItemCount') as "protected_item_count",
JSON_EXTRACT(properties, '$.allowedScenarios') as "allowed_scenarios",
JSON_EXTRACT(properties, '$.healthErrorDetails') as "health_error_details",
JSON_EXTRACT(properties, '$.draIdentifier') as "dra_identifier",
JSON_EXTRACT(properties, '$.machineId') as "machine_id",
JSON_EXTRACT(properties, '$.machineName') as "machine_name",
JSON_EXTRACT(properties, '$.biosId') as "bios_id",
JSON_EXTRACT(properties, '$.authenticationIdentityDetails') as "authentication_identity_details",
JSON_EXTRACT(properties, '$.resourceAccessIdentityDetails') as "resource_access_identity_details",
JSON_EXTRACT(properties, '$.dataPlaneAuthenticationIdentityDetails') as "data_plane_authentication_identity_details",
JSON_EXTRACT(properties, '$.providerVersionDetails') as "provider_version_details",
subscriptionId,
resourceGroupName,
resourceName,
fabricName,
providerName
FROM azure.recovery_services_site_recovery.replication_recovery_services_providers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND resourceName = 'replace-me';