Get-ElasticPoolSummaryReport

Azure: Gets a summary report of Elastic Pools

Script

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

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

try {
	Import-Module Az.Sql -ErrorAction Stop
	$pools = Get-AzSqlElasticPool -ResourceGroupName $ResourceGroupName -ServerName $ServerName -ErrorAction Stop | Select-Object ElasticPoolName, State, Edition, Dtu, DatabaseDtuMax
	Write-Output $pools
} catch {
	Write-Error $_
	exit 1
}

Customize

ResourceGroupName string

The name of the resource group.

ServerName string

The name of the Azure SQL Server.