SQL - query to find backup time set for virtual machines

Question

How can I find the scheduled time set for automatic backups by Virtual Machine?

Environment

OnApp 3.x-6.x

Answer

Below are the queries for the database that will pull the virtual machine information and link to the schedules for backups so that schedules can have the time scheduled to run modified.

For Standard Backups:

select vm.label,vm.identifier,s.id,s.period,s.start_at from virtual_machines vm join disks d on vm.id = d.virtual_machine_id join schedules s on d.id = s.target_id where s.status='enabled' and s.target_type='disk' order by s.target_id;

For Incremental Backups:

select vm.label,vm.identifier,s.id,s.period,s.start_at from virtual_machines vm join schedules s on vm.id = s.target_id where s.status='enabled' and s.target_type='VirtualMachine' order by s.target_id;/pre>