Get Azure SQL server information using Powershell?

Question

How can I get these information using the Azure Powershell module ?

Subscription
ResourceGrpName
SQLServerName
Region
SQLFQDN(*.database.windows.net)
SQLServerTLSVersion
SQLServerPublicNetworkAccess
SQLAdminLogin
SQLSrvAADEnabledStatus
SQLServerAPTStatus

By combining these:
https://learn.microsoft.com/en-us/powershell/module/az.sql/get-azsqlserver?view=azps-6.2.1
https://learn.microsoft.com/en-us/powershell/module/az.sql/get-azsqldatabase?view=azps-6.2.1
https://learn.microsoft.com/en-us/powershell/module/az.sql/get-azsqlserveractivedirectoryadministrator?view=azps-6.2.1

Thanks in advance.

Answer 1

Hi @EnterpriseArchitect Thank you for posting your question.
I don't think it is possible in one PowerShell script to get all information you listed above but you can try the following GetAzSqlServer -ResourceGroupName " " -ServerName " "

The term SQLSrvAADEnabledStatus was not recognized as a name of commandlet, function or script file so I replaced it with Get-AzSqlServer -ServerName myserver | Get-AzSqlServerActiveDirectoryOnlyAuthentication

Please let me know if this is not what you are looking for.

Regards,
Oury