$Parameters = @{ subscription = '40c3c7b3-1bd7-446b-b6a3-45ac84246fb9' ResourceGroupName = 'rg-Tot-resources-weu01' StorageAccountName = 'rosertotalbackup' StorageContainerName = 'backupcontainer' } $ContainerContent = ./Get-StorageContainerContent.ps1 @Parameters | sort-object -Property LastModified -Descending $ContainerContent | Where-object { $_.Name -like '*.bak'} | Out-GridView $ParamAzSql = @{ ResourceGroupName = $Parameters.ResourceGroupName } 'tot-managed-sql-production','tot-2020-sql-production' | ForEach-Object { $ParamAzSql.InstanceName = $_ Get-AzSqlInstanceDatabase @ParamAzSql | Get-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy } | Out-GridView