Skip to main content

vw_replication_jobs

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

Overview​

Namevw_replication_jobs
TypeView
Idazure.recovery_services_site_recovery.vw_replication_jobs

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, '$.activityId') as "activity_id",
JSON_EXTRACT(properties, '$.scenarioName') as "scenario_name",
JSON_EXTRACT(properties, '$.friendlyName') as "friendly_name",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.stateDescription') as "state_description",
JSON_EXTRACT(properties, '$.tasks') as "tasks",
JSON_EXTRACT(properties, '$.errors') as "errors",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.endTime') as "end_time",
JSON_EXTRACT(properties, '$.allowedActions') as "allowed_actions",
JSON_EXTRACT(properties, '$.targetObjectId') as "target_object_id",
JSON_EXTRACT(properties, '$.targetObjectName') as "target_object_name",
JSON_EXTRACT(properties, '$.targetInstanceType') as "target_instance_type",
JSON_EXTRACT(properties, '$.customDetails') as "custom_details",
subscriptionId,
resourceGroupName,
resourceName,
jobName
FROM azure.recovery_services_site_recovery.replication_jobs
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND resourceName = 'replace-me';