< Back
Get-AzureRmSqlServer
Post
NAME Get-AzureRmSqlServer
SYNOPSIS
Returns information about SQL Database servers.
SYNTAX
Get-AzureRmSqlServer [[-ResourceGroupName] <String>] [[-ServerName] <String>] [-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf]
[<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlServer cmdlet returns information about one or more Azure SQL Database servers. Specify the name of a server to see information
for only that server.
PARAMETERS
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which servers are assigned.
Required? false
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server that this cmdlet gets.
Required? false
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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 (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Server.Model.AzureSqlServerModel
NOTES
Example 1: Get all instances of SQL Server assigned to a resource group
PS C:\\>Get-AzureRmSqlServer -ResourceGroupName "ResourceGroup01"
ResourceGroupName : resourcegroup01
ServerName : server01
Location : Central US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server01.database.windows.net
ResourceGroupName : resourcegroup01
ServerName : server02
Location : West US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server02.database.windows.net
This command gets information about all the Azure SQL Database servers assigned to the resource group ResourceGroup01.
Example 2: Get information about an Azure SQL Database server
PS C:\\>Get-AzureRmSqlServer -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
ResourceGroupName : resourcegroup01
ServerName : server01
Location : Central US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server01.database.windows.net
This command gets information about the Azure SQL Database server named Server01.
Example 3: Get all instances of SQL Server in the subscription
PS C:\\>Get-AzureRmResourceGroup | Get-AzureRmSqlServer
ResourceGroupName : resourcegroup01
ServerName : server01
Location : Central US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server01.database.windows.net
ResourceGroupName : resourcegroup01
ServerName : server02
Location : West US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server02.database.windows.net
ResourceGroupName : resourcegroup02
ServerName : server03
Location : East US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server03.database.windows.net
This command gets information about all the Azure SQL Database servers in the current subscription.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... msqlserver
New-AzureRmSqlServer
Remove-AzureRmSqlServerAuditing
Set-AzureRmSqlServerAuditingPolicy
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Returns information about SQL Database servers.
SYNTAX
Get-AzureRmSqlServer [[-ResourceGroupName] <String>] [[-ServerName] <String>] [-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf]
[<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlServer cmdlet returns information about one or more Azure SQL Database servers. Specify the name of a server to see information
for only that server.
PARAMETERS
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of the resource group to which servers are assigned.
Required? false
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of the server that this cmdlet gets.
Required? false
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
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 (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Server.Model.AzureSqlServerModel
NOTES
Example 1: Get all instances of SQL Server assigned to a resource group
PS C:\\>Get-AzureRmSqlServer -ResourceGroupName "ResourceGroup01"
ResourceGroupName : resourcegroup01
ServerName : server01
Location : Central US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server01.database.windows.net
ResourceGroupName : resourcegroup01
ServerName : server02
Location : West US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server02.database.windows.net
This command gets information about all the Azure SQL Database servers assigned to the resource group ResourceGroup01.
Example 2: Get information about an Azure SQL Database server
PS C:\\>Get-AzureRmSqlServer -ResourceGroupName "ResourceGroup01" -ServerName "Server01"
ResourceGroupName : resourcegroup01
ServerName : server01
Location : Central US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server01.database.windows.net
This command gets information about the Azure SQL Database server named Server01.
Example 3: Get all instances of SQL Server in the subscription
PS C:\\>Get-AzureRmResourceGroup | Get-AzureRmSqlServer
ResourceGroupName : resourcegroup01
ServerName : server01
Location : Central US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server01.database.windows.net
ResourceGroupName : resourcegroup01
ServerName : server02
Location : West US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server02.database.windows.net
ResourceGroupName : resourcegroup02
ServerName : server03
Location : East US
SqlAdministratorLogin : adminLogin
SqlAdministratorPassword :
ServerVersion : 12.0
Tags :
Identity :
FullyQualifiedDomainName : server03.database.windows.net
This command gets information about all the Azure SQL Database servers in the current subscription.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... msqlserver
New-AzureRmSqlServer
Remove-AzureRmSqlServerAuditing
Set-AzureRmSqlServerAuditingPolicy
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/