Want a query to get information of oldest recovery point for Azure Disk Backup from All backup vault

Shaikh, Shahid 1

this will help to understand which can we retained futher or deleted and also the capacity it is taking for backup

Bechir Gharbi 301 Reputation points

2024-09-19T12:25:44.37+00:00

Hi,

there are many ways to do it, by using Azure CLI, Powershell or even by Azure Resource Graph Explorer.
Shaikh, Shahid 1 Reputation point

2024-09-20T07:53:36.83+00:00

can you share a sample cmmand for CLI as well as Powershell and Azure Resource Graph.. whichever helps me we will do it.

SadiqhAhmed-MSFT 45,591 Microsoft Employee

@Shaikh, Shahid To get information about the oldest recovery point for Azure Disk Backup from all backup vaults, you can use Azure CLI, PowerShell, or Azure Resource Graph Explorer. Here are some sample commands for each method:

Azure CLI

az backup recoverypoint list --resource-group <ResourceGroupName> --vault-name <VaultName> --container-name <ContainerName> --item-name <ItemName> --query "[?properties.recoveryPointType=='Full'].{RecoveryPoint:properties.recoveryPointTime}" --output table

PowerShell

$vault = Get-AzRecoveryServicesVault -ResourceGroupName <ResourceGroupName> -Name <VaultName>
$container = Get-AzRecoveryServicesBackupContainer -VaultId $vault.ID -FriendlyName <ContainerName>
$item = Get-AzRecoveryServicesBackupItem -Container $container -Name <ItemName>
$recoveryPoints = Get-AzRecoveryServicesBackupRecoveryPoint -Item $item
$oldestRecoveryPoint = $recoveryPoints | Sort-Object -Property RecoveryPointTime | Select-Object -First 1
$oldestRecoveryPoint

Azure Resource Graph Explorer

You can use the following query in Azure Resource Graph Explorer to get the oldest recovery point:

Resources
| where type == "microsoft.recoveryservices/vaults/backupFabrics/protectionContainers/protectedItems/recoveryPoints"
| project recoveryPointTime = properties.recoveryPointTime, recoveryPointType = properties.recoveryPointType
| where recoveryPointType == "Full"
| sort by recoveryPointTime asc
| limit 1

These commands will help you identify the oldest recovery point, which can then be evaluated for retention or deletion based on the capacity it is taking for backup. If you need further assistance, feel free to ask!

Hope this helps!

Share via

Want a query to get information of oldest recovery point for Azure Disk Backup from All backup vault

Your answer