Skip to main content

vw_operation_results

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

Overview​

Namevw_operation_results
TypeView
Idazure.recovery_services.vw_operation_results

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
identity as identity,
sku as sku,
systemData as system_data,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.upgradeDetails') as "upgrade_details",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.privateEndpointStateForBackup') as "private_endpoint_state_for_backup",
JSON_EXTRACT(properties, '$.privateEndpointStateForSiteRecovery') as "private_endpoint_state_for_site_recovery",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
JSON_EXTRACT(properties, '$.moveDetails') as "move_details",
JSON_EXTRACT(properties, '$.moveState') as "move_state",
JSON_EXTRACT(properties, '$.backupStorageVersion') as "backup_storage_version",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.monitoringSettings') as "monitoring_settings",
JSON_EXTRACT(properties, '$.restoreSettings') as "restore_settings",
JSON_EXTRACT(properties, '$.redundancySettings') as "redundancy_settings",
JSON_EXTRACT(properties, '$.securitySettings') as "security_settings",
JSON_EXTRACT(properties, '$.secureScore') as "secure_score",
JSON_EXTRACT(properties, '$.bcdrSecurityLevel') as "bcdr_security_level",
JSON_EXTRACT(properties, '$.resourceGuardOperationRequests') as "resource_guard_operation_requests",
subscriptionId,
resourceGroupName,
vaultName,
operationId
FROM azure.recovery_services.operation_results
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vaultName = 'replace-me' AND operationId = 'replace-me';