Skip to main content

vw_virtual_machine_run_commands

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

Overview​

Namevw_virtual_machine_run_commands
TypeView
Idazure.compute.vw_virtual_machine_run_commands

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,
tags as tags,
JSON_EXTRACT(properties, '$.source') as "source",
JSON_EXTRACT(properties, '$.parameters') as "parameters",
JSON_EXTRACT(properties, '$.protectedParameters') as "protected_parameters",
JSON_EXTRACT(properties, '$.asyncExecution') as "async_execution",
JSON_EXTRACT(properties, '$.runAsUser') as "run_as_user",
JSON_EXTRACT(properties, '$.runAsPassword') as "run_as_password",
JSON_EXTRACT(properties, '$.timeoutInSeconds') as "timeout_in_seconds",
JSON_EXTRACT(properties, '$.outputBlobUri') as "output_blob_uri",
JSON_EXTRACT(properties, '$.errorBlobUri') as "error_blob_uri",
JSON_EXTRACT(properties, '$.outputBlobManagedIdentity') as "output_blob_managed_identity",
JSON_EXTRACT(properties, '$.errorBlobManagedIdentity') as "error_blob_managed_identity",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.instanceView') as "instance_view",
JSON_EXTRACT(properties, '$.treatFailureAsDeploymentFailure') as "treat_failure_as_deployment_failure",
subscriptionId,
resourceGroupName,
vmName,
runCommandName,
location
FROM azure.compute.virtual_machine_run_commands
WHERE subscriptionId = 'replace-me' AND location = 'replace-me';