Get-DatabaseSummaryReport

Azure: Gets a summary report of SQL databases

Script

param(
	[Parameter(Mandatory = $true)]
	[string]$ResourceGroupName,

	[Parameter(Mandatory = $true)]
	[string]$ServerName
)

try {
	Import-Module Az.Sql -ErrorAction Stop
	$databases = Get-AzSqlDatabase -ResourceGroupName $ResourceGroupName -ServerName $ServerName -ErrorAction Stop | Select-Object DatabaseName, Status, Edition, ServiceObjectiveName, CreationDate
	Write-Output $databases
} catch {
	Write-Error $_
	exit 1
}

Customize

ResourceGroupName string

The name of the resource group.

ServerName string

The name of the Azure SQL Server.