Get-AzureVMSqlServerExtension

NAME Get-AzureVMSqlServerExtension



SYNOPSIS

Gets the settings of the SQL Server IaaS Agent on a particular virtual machine.





SYNTAX

Get-AzureVMSqlServerExtension -VM <IPersistentVM> [-Profile <AzureSMProfile>] [-InformationAction <ActionPreference>] [-InformationVariable <String>]

[<CommonParameters>]





DESCRIPTION

The Get-AzureVMSqlServerExtension cmdlet gets the settings of the SQL Server infrastructure as a service (IaaS) Agent on a particular virtual machine.





PARAMETERS

-VM <IPersistentVM>

Specifies the persistent virtual machine object that this cmdlet gets settings from.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByValue, ByPropertyName)

Accept wildcard characters? false



-Profile <AzureSMProfile>

Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.



Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-InformationAction <ActionPreference>





Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-InformationVariable <String>





Required? false

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



NOTES









-------------------------- Example 1: Get the settings of a SQL Server extension on a virtual machine --------------------------



PS C:\\>Get-AzureVMSqlServerExtension-VM $VM

ExtensionName : SqlIaaSAgent

Publisher : Microsoft.SqlServer.Management

Version : 1.0

State : Enable

RoleName : VMName

AutoPatchingSettings : Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.Extensions.AutoPatchingSettings

AutoBackupSettings : Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.Extensions.AutoBackupSettings



Gets the settings of the SQL Server extension on a particular virtual machine.

-------------------------- Example 2: Get the settings of a SQL Server IaaS Agent on a virtual machine --------------------------



PS C:\\>Get-AzureVM -ServiceName "Service" -Name "VMName" | Get-AzureVMSqlServerExtension

ExtensionName : SqlIaaSAgent

Publisher : Microsoft.SqlServer.Management

Version : 1.0

State : Enable

RoleName : VMName

AutoPatchingSettings : Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.Extensions.AutoPatchingSettings

AutoBackupSettings : Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.Extensions.AutoBackupSettings



Gets the settings of the SQL Server IaaS Agent on a particular virtual machine using piped input.

-------------------------- Example 3: Get the settings of specific SQL Server version IaaS Agent on a virtual machine --------------------------



PS C:\\>Get-AzureVMSqlServerExtension -VM $VM -Version "1.0"

ExtensionName : SqlIaaSAgent

Publisher : Microsoft.SqlServer.Management

Version : 1.0

State : Enable

RoleName : VMName

AutoPatchingSettings : Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.Extensions.AutoPatchingSettings

AutoBackupSettings : Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.Extensions.AutoBackupSettings



This command gets the settings of the particular version of SQL Server IaaS Agent on a virtual machine.



RELATED LINKS

Remove-AzureVMSqlServerExtension

Set-AzureVMSqlServerExtension