Skip to main content

vw_managed_instance_operations

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

Overview​

Namevw_managed_instance_operations
TypeView
Idazure.sql.vw_managed_instance_operations

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.managedInstanceName') as "managed_instance_name",
JSON_EXTRACT(properties, '$.operation') as "operation",
JSON_EXTRACT(properties, '$.operationFriendlyName') as "operation_friendly_name",
JSON_EXTRACT(properties, '$.percentComplete') as "percent_complete",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.errorCode') as "error_code",
JSON_EXTRACT(properties, '$.errorDescription') as "error_description",
JSON_EXTRACT(properties, '$.errorSeverity') as "error_severity",
JSON_EXTRACT(properties, '$.isUserError') as "is_user_error",
JSON_EXTRACT(properties, '$.estimatedCompletionTime') as "estimated_completion_time",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.isCancellable') as "is_cancellable",
JSON_EXTRACT(properties, '$.operationParameters') as "operation_parameters",
JSON_EXTRACT(properties, '$.operationSteps') as "operation_steps",
subscriptionId,
resourceGroupName,
managedInstanceName,
operationId
FROM azure.sql.managed_instance_operations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managedInstanceName = 'replace-me' AND operationId = 'replace-me';