Get-AzMariaDbServer
This cmdlet is part of a Preview module. Preview versions aren't recommended for use in production environments. For more information, see https://aka.ms/azps-refstatus.
Gets information about a server.
Syntax
List1 (Default)
Get-AzMariaDbServer
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Get
Get-AzMariaDbServer
-Name <String>
-ResourceGroupName <String>
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
List
Get-AzMariaDbServer
-ResourceGroupName <String>
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
GetViaIdentity
Get-AzMariaDbServer
-InputObject <IMariaDbIdentity>
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Description
Gets information about a server.
Examples
Example 1: List all MariaDB under a subscriptions
Get-AzMariaDbServer
Name Location AdministratorLogin Version StorageProfileStorageMb SkuName SkuTier SslEnforcement
---- -------- ------------------ ------- ----------------------- ------- ------- --------------
mrdb01 eastus dolauli 10.2 5120 B_Gen5_1 Basic Enabled
wyunchi-10 eastus wyunchi 10.2 5120 GP_Gen5_4 GeneralPurpose Enabled
wyunchi eastus wyunchi 10.2 5120 GP_Gen5_4 GeneralPurpose Enabled
wyunchi-eastus eastus wyunchi 10.2 5120 GP_Gen5_4 GeneralPurpose Enabled
mariadb-test-h3pame eastus qiszomtkpf 10.2 5120 B_Gen5_1 Basic Enabled
mariadb-test-4rmtig eastus xofavpndqj 10.2 5120 B_Gen5_1 Basic Enabled
mariadb-test-szp6dt eastus zmoxhpgjqc 10.2 5120 GP_Gen5_4 GeneralPurpose Enabled
mariadb-test-9pebvn eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
mariadb-test-szp6dt-rep428 eastus zmoxhpgjqc 10.2 5120 GP_Gen5_4 GeneralPurpose Enabled
mariadb-asd-01 eastus adminuser 10.2 5120 B_Gen5_1 Basic Enabled
rst-001 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
rst-002 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
rstrgp02-rep-003 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
rstrgp02-rep-004 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
This command lists all MariaDB under a subscriptions.
Example 2: List all MariaDB under a resource group
Get-AzMariaDbServer -ResourceGroupName mariadb-test-qu5ov0
Name Location AdministratorLogin Version StorageProfileStorageMb SkuName SkuTier SslEnforcement
---- -------- ------------------ ------- ----------------------- ------- ------- --------------
mariadb-test-h3pame eastus qiszomtkpf 10.2 5120 B_Gen5_1 Basic Enabled
mariadb-test-4rmtig eastus xofavpndqj 10.2 5120 B_Gen5_1 Basic Enabled
mariadb-test-szp6dt eastus zmoxhpgjqc 10.2 5120 GP_Gen5_4 GeneralPurpose Enabled
mariadb-test-9pebvn eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
mariadb-test-szp6dt-rep428 eastus zmoxhpgjqc 10.2 5120 GP_Gen5_4 GeneralPurpose Enabled
mariadb-asd-01 eastus adminuser 10.2 5120 B_Gen5_1 Basic Enabled
rst-001 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
rst-002 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
rstrgp02-rep-003 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
rstrgp02-rep-004 eastus xpwjyfdgui 10.2 7168 GP_Gen5_4 GeneralPurpose Enabled
This command lists all MariaDB under a resource group.
Example 3: Get a MariaDB
Get-AzMariaDbServer -ResourceGroupName mariadb-test-qu5ov0 -Name mariadb-test-h3pame
Name Location AdministratorLogin Version StorageProfileStorageMb SkuName SkuTier SslEnforcement
---- -------- ------------------ ------- ----------------------- ------- ------- --------------
mariadb-test-h3pame eastus qiszomtkpf 10.2 5120 B_Gen5_1 Basic Enabled
This command gets a MariaDB.
Parameters
-DefaultProfile
The DefaultProfile parameter is not functional. Use the SubscriptionId parameter when available if executing the cmdlet against a different subscription.
Parameter properties
| Type: | PSObject |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | AzureRMContext, AzureCredential |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-InputObject
Identity Parameter To construct, see NOTES section for INPUTOBJECT properties and create a hash table.
Parameter properties
| Type: | IMariaDbIdentity |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
GetViaIdentity
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | True |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-Name
The name of the server.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | ServerName |
Parameter sets
Get
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-ResourceGroupName
The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
Get
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
List
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-SubscriptionId
The subscription ID that identifies an Azure subscription.
Parameter properties
| Type: | String[] |
| Default value: | (Get-AzContext).Subscription.Id |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
List1
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
Get
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
List
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.