Skip to main content

sql_virtual_machine_troubleshoot

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

Overview

Namesql_virtual_machine_troubleshoot
TypeResource
Idazure.sql_vm.sql_virtual_machine_troubleshoot

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
troubleshootexecresourceGroupName, sqlVirtualMachineName, subscriptionIdStarts SQL virtual machine troubleshooting.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resourceGroupNamestringName of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
sqlVirtualMachineNamestringName of the SQL virtual machine.
subscriptionIdstringThe ID of the target subscription.

Lifecycle Methods

Starts SQL virtual machine troubleshooting.

EXEC azure.sql_vm.sql_virtual_machine_troubleshoot.troubleshoot 
@resourceGroupName='{{ resourceGroupName }}' --required,
@sqlVirtualMachineName='{{ sqlVirtualMachineName }}' --required,
@subscriptionId='{{ subscriptionId }}' --required
@@json=
'{
"startTimeUtc": "{{ startTimeUtc }}",
"endTimeUtc": "{{ endTimeUtc }}",
"troubleshootingScenario": "{{ troubleshootingScenario }}",
"properties": "{{ properties }}"
}'
;