Get-AzMariaDbServer
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
Identity Parameter
To construct, see NOTES section for INPUTOBJECT properties and create a hash table.
Type: IMariaDbIdentity
Default value: None
Supports wildcards: False
DontShow: False
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 .
Outputs