I am writing a powershell script to check the backup items for SQL VM in the Recovery service vault. My script looks like below, it loops through the subscription and find all Vaults and then all container in those vaults and list the backup items. However, it only return instance backups, not Always On backups.
$Subscritions=Get-AzSubscription | Where-Object {$_.name -like "abc1*"}
foreach ($subscition in $Subscritions)
{
$subscition |Set-AzContext
$vaults = Get-AzRecoveryServicesVault
foreach($vault in $vaults)
{
$Containers =Get-AzRecoveryServicesBackupContainer -ContainerType "AzureVMAppContainer" -Status "Registered" -VaultId $vault.ID
foreach ($container in $Containers )
{
$backupitem=Get-AzRecoveryServicesBackupItem -Container $Container -WorkloadType MSSQL -VaultId $vault.ID
$backupitem |select -Property friendlyname, SErvername |ft
}
# $backupitem=$backupitem |select -Property ServerName,name, ProtectionStatus, LastBackupTime,LatestRecoveryPoint,ProtectionState,LastBackupErrorDetail,LastBackupStatus| out-datatable
# Write-DataTable -Data $backupitem -ServerInstance YCHEN-LT -Database t1 -TableName dbo.BackupStatus
}