Get-AzSqlInstancePool

參考

模組:: Az.Sql

傳回 Azure SQL 實例集區的相關信息。

語法

Get-AzSqlInstancePool
   [-ResourceGroupName <String>]
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]

Get-AzSqlInstancePool
   -ResourceGroupName <String>
   [-Name] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]

Get-AzSqlInstancePool
   [-ResourceId] <String>
   [-DefaultProfile <IAzureContextContainer>]
   [<CommonParameters>]

Description

Get-AzSqlInstancePool Cmdlet 會傳回一或多個 Azure SQL 實例集區的相關信息。指定實例集區的名稱，只查看該實例集區的資訊。

範例

範例 1：取得客戶訂用帳戶中的所有實例集區

Get-AzSqlInstancePool

ResourceGroupName          : resourcegroup01
Type                       : Microsoft.Sql/instancePools
Id                         : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0
InstancePoolName           : instancePool0
SubnetId                   : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores                     : 8
ComputeGeneration          : Gen5
Edition                    : GeneralPurpose
Tags                       :
Sku                        : Microsoft.Azure.Management.Sql.Models.Sku
Location                   : canadacentral
LicenseType                : LicenseIncluded
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1

ResourceGroupName          : resourcegroup02
Type                       : Microsoft.Sql/instancePools
Id                         : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup02/providers/Microsoft.Sql/instancePools/ps-instancepool-1
InstancePoolName           : instancePool0
SubnetId                   : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup02/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores                     : 8
ComputeGeneration          : Gen5
Edition                    : GeneralPurpose
Tags                       :
Sku                        : Microsoft.Azure.Management.Sql.Models.Sku
Location                   : canadacentral
LicenseType                : LicenseIncluded
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1

此命令會取得客戶訂用帳戶內所有實例集區的相關信息。

範例 2：取得資源群組中的所有實例集區

Get-AzSqlInstancePool -ResourceGroupName resourcegroup01

ResourceGroupName          : resourcegroup01
Type                       : Microsoft.Sql/instancePools
Id                         : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0
InstancePoolName           : instancePool0
SubnetId                   : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores                     : 8
ComputeGeneration          : Gen5
Edition                    : GeneralPurpose
Tags                       :
Sku                        : Microsoft.Azure.Management.Sql.Models.Sku
Location                   : canadacentral
LicenseType                : LicenseIncluded
DnsZone                    : 1234567890
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1

此命令會取得資源群組 resourcegroup01 內所有實例集區的相關信息。

範例 3：取得實例集區的相關信息

Get-AzSqlInstancePool -ResourceGroupName resourcegroup01 -Name instancePool0

ResourceGroupName          : resourcegroup01
Type                       : Microsoft.Sql/instancePools
Id                         : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0
InstancePoolName           : instancePool0
SubnetId                   : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores                     : 8
ComputeGeneration          : Gen5
Edition                    : GeneralPurpose
Tags                       :
Sku                        : Microsoft.Azure.Management.Sql.Models.Sku
Location                   : canadacentral
LicenseType                : LicenseIncluded
DnsZone                    : 1234567890
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1

此命令會取得實例集區 instancePool0 的相關信息。

範例 4：使用實例集區資源標識符取得實例集區的相關信息

Get-AzSqlInstancePool -ResourceId "/subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0"

ResourceGroupName          : resourcegroup01
Type                       : Microsoft.Sql/instancePools
Id                         : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Sql/instancePools/instancePool0
InstancePoolName           : instancePool0
SubnetId                   : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/resourceGroups/resourcegroup01/providers/Microsoft.Network/virtualNetworks/vnet_name/subnets/subnet_name
VCores                     : 8
ComputeGeneration          : Gen5
Edition                    : GeneralPurpose
Tags                       :
Sku                        : Microsoft.Azure.Management.Sql.Models.Sku
Location                   : canadacentral
LicenseType                : LicenseIncluded
DnsZone                    : 1234567890
MaintenanceConfigurationId : /subscriptions/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_canadacentral_MI_1

此命令會取得實例集區及其資源標識符的相關信息。

參數

-DefaultProfile

用於與 Azure 通訊的認證、帳戶、租用戶和訂用帳戶。

類型:	IAzureContextContainer
別名:	AzContext, AzureRmContext, AzureCredential
Position:	Named
預設值:	None
必要:	False
接受管線輸入:	False
接受萬用字元:	False

-Name

實例集區名稱。

類型:	String
別名:	InstancePoolName
Position:	1
預設值:	None
必要:	True
接受管線輸入:	False
接受萬用字元:	False

-ResourceGroupName

資源組名。

類型:	String
Position:	Named
預設值:	None
必要:	True
接受管線輸入:	False
接受萬用字元:	False

-ResourceId

實例集區資源標識碼。

類型:	String
Position:	0
預設值:	None
必要:	True
接受管線輸入:	True
接受萬用字元:	False

輸入

None

輸出

AzureSqlInstancePoolModel

共用方式為