Get-AzureSqlElasticPool

Get-AzureSqlElasticPool

Gets elastic pools and their property values in an Azure SQL Database.

Syntax

Parameter Set: Default
Get-AzureSqlElasticPool [-ResourceGroupName] <System.String> [-ServerName] <System.String> [[-ElasticPoolName] <System.String> ] [-Profile <Microsoft.Azure.Common.Authentication.Models.AzureProfile> ] 

Detailed Description

The Get-AzureSqlElasticPool cmdlet gets elastic pools and their property values in an Azure SQL Database. Specify the name of an existing elastic pool to see the property values for only that pool.

Parameters

-ElasticPoolName<System.String>

Specifies the name of the elastic pool that this cmdlet gets.

Aliases

none

Required?

false

Position?

3

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

-Profile<Microsoft.Azure.Common.Authentication.Models.AzureProfile>

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

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ResourceGroupName<System.String>

Specifies the name of the resource group that contains the elastic pool that this cmdlet gets.

Aliases

none

Required?

true

Position?

1

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

-ServerName<System.String>

Specifies the name of the server that contains the elastic pool that this cmdlet gets.

Aliases

none

Required?

true

Position?

2

Default Value

none

Accept Pipeline Input?

true(ByPropertyName)

Accept Wildcard Characters?

false

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • InputType

    System.String

Outputs

The output type is the type of the objects that the cmdlet emits.

  • OutputType

    System.Object

Notes

  • This cmdlet supports the common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see about_CommonParameters.

Examples

Example 1: Get all elastic pools

This command gets all elastic pools on the server named Server01.

PS C:\> Get-AzureSqlElasticPool -ResourceGroupName "ResourceGroup11" -ServerName "Server01"

Example 2: Get a specific elastic pool

This command gets the elastic pool named ElasticPool27 on the server named Server01.

PS C:\> Get-AzureSqlElasticPool -ResourceGroupName "ResourceGroup11" -ServerName "Server01" -ElasticPoolName "ElasticPool27"

Azure SQL Database

New-AzureSqlElasticPool

Remove-AzureSqlElasticPool

Set-AzureSqlElasticPool