How can I find the VM associated with a backup ID?
All OnApp Versions
***Please see this article for additional details about working with the OnApp database***
3.x and above:
With the introduction of incremental backups, the backup can be either associated to a disk as with the original style backups or it can be associated to a Virtual Machine if it is an incremental backup. You will need either the Virtual Machine ID or the backup ID. Then run:
select vm.identifier,vm.hostname from virtual_machines as vm JOIN disks d ON vm.id=d.virtual_machine_id JOIN backups b ON d.id=b.target_id where b.id=xx;
You can find a VM association with a particular backup transaction with the following statement:
select vm.identifier,vm.hostname from virtual_machines as vm JOIN disks d ON vm.id=d.virtual_machine_id JOIN backups b ON d.id=b.disk_id where b.id=XXXX;