Get-AzSQLDBInventory.ps1

$AvailableContexts = Get-AzContext -ListAvailable 

$AllSQLServers = foreach ($Context in $AvailableContexts)
{ 
    $SqlServer = Get-AzSqlServer -DefaultProfile $Context
    if ($SqlServer)
    {
        $SqlServer | ForEach-Object { Add-Member -InputObject $_ -MemberType NoteProperty -Name Context -Value $Context }
    }
    $SqlServer
} 

$AllDatabases = foreach ($Server in $AllSQLServers)
{
    $Databases = Get-AzSqlDatabase -ServerName $Server.ServerName -ResourceGroupName $Server.ResourceGroupName -DefaultProfile $Server.Context
    if ($Databases)
    {
        $Databases | ForEach-Object { 
            $BackupState = Get-AzSqlDatabaseGeoBackupPolicy -ServerName $Server.ServerName -DatabaseName $_.DatabaseName -ResourceGroupName $Server.ResourceGroupName -DefaultProfile $Server.Context | Select-Object -ExpandProperty State
            Add-Member -InputObject $_ -MemberType NoteProperty -Name BackupState -Value $BackupState 
            Add-Member -InputObject $_ -MemberType NoteProperty -Name SubscriptionName -Value $Server.Context.Subscription.Name 
        }
    }
    $Databases
} 

$AllDatabases | Select-Object SubscriptionName, ResourceGroupName, ServerName, DatabaseName, CreationDate, BackupState