How can I tell how the pending / running backups are split among my HVs?
OnApp Cloud (All Versions)
Due to limitations for backups that can be set on the configuration page of your OnApp UI, you may need to know how the backups are distributed among your HVs, or how many are running at a time on one HV.
***Please see this article for additional details about working with the OnApp database***
select h.label as "HV",count(b.id) as "Backups" from transactions t join backups b on t.parent_id=b.id join disks d on b.disk_id=d.id join virtual_machines v on d.virtual_machine_id=v.id join hypervisors h on v.hypervisor_id=h.id where t.action="take_backup" and t.status in ("pending","running") group by h.label;