sql_virtual_machines

Overview

Name	sql_virtual_machines
Type	Resource
Id	azure.sql_vm.sql_virtual_machines

Fields

Name	Datatype	Description
identity	object	Azure Active Directory identity configuration for a resource.
location	string	Resource location.
properties	object	The SQL virtual machine properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlVirtualMachineName, subscriptionId	Gets a SQL virtual machine.
list	SELECT	subscriptionId	Gets all SQL virtual machines in a subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all SQL virtual machines in a resource group.
list_by_sql_vm_group	SELECT	resourceGroupName, sqlVirtualMachineGroupName, subscriptionId	Gets the list of sql virtual machines in a SQL virtual machine group.
create_or_update	INSERT	resourceGroupName, sqlVirtualMachineName, subscriptionId, data__location	Creates or updates a SQL virtual machine.
delete	DELETE	resourceGroupName, sqlVirtualMachineName, subscriptionId	Deletes a SQL virtual machine.
_list	EXEC	subscriptionId	Gets all SQL virtual machines in a subscription.
_list_by_resource_group	EXEC	resourceGroupName, subscriptionId	Gets all SQL virtual machines in a resource group.
_list_by_sql_vm_group	EXEC	resourceGroupName, sqlVirtualMachineGroupName, subscriptionId	Gets the list of sql virtual machines in a SQL virtual machine group.
redeploy	EXEC	resourceGroupName, sqlVirtualMachineName, subscriptionId	Uninstalls and reinstalls the SQL IaaS Extension.
start_assessment	EXEC	resourceGroupName, sqlVirtualMachineName, subscriptionId	Starts SQL best practices Assessment on SQL virtual machine.
update	EXEC	resourceGroupName, sqlVirtualMachineName, subscriptionId	Updates a SQL virtual machine.