Hello,
I have two working queries that are somewhat related and would like to combine.
[pre]
$resourceGroup = “azure-rg”
$serverName = “azure-srv1”
$dbName = “azure01”
$params = @{
ResourceGroupName = $resourceGroup;
ServerName = $serverName;
DatabaseName = $dbName;
}
Get-AzSqlDatabaseRestorePoints @params | Select-Object ServerName, DatabaseName, Location, EarliestRestoreDate
[/pre]
…and the second:
[pre]
$resourceGroup = “azure-rg”
$serverName = “azure-srv1”
$params = @{
ResourceGroupName = $resourceGroup;
ServerName = $serverName;
}
Get-AzSqlDatabaseGeoBackup @params | Select-Object ServerName, DatabaseName, Edition, LastAvailableBackupDate
[/pre]
I’d like to combine the output from both to show:
ServerName, DatabaseName, Edition, LastAvailableBackupDate, Location, EarliestRestoreDate
Any help would be appreciated!
Frank