#Get All Recovery Services Vaults
$vaults = Get-AzureRMRecoveryServicesVault

#Loop through all RS Vaults and output details for each container (VM)
foreach ($vault in $vaults)
{
    Set-AzureRmRecoveryServicesVaultContext -Vault $vault
    $containers = Get-AzureRmRecoveryServicesBackupContainer -ContainerType "AzureVM"

    foreach ($container in $containers)
    {
        $item = Get-AzureRmRecoveryServicesBackupItem -Container $container -WorkloadType "AzureVM" #| select ContainerName,LatestRecoveryPoint
        Write-Output "$($container.FriendlyName), $($container.ResourceGroupName), $($container.Status), $($item.ProtectionPolicyName), $($item.LatestRecoveryPoint), $($vault.Name), $($vault.ResourceGroupName), $($vault.Location)"
    }

}