1 -- report backups and corresponding dvd
3 create view backups_on_dvds as
6 hosts.name || ':' || shares.name as share,
9 abstime(backups.date) as backup_date,
11 backups.inc_size as gzip_size,
12 archive.id as archive_id,
15 join shares on backups.shareid=shares.id
16 join hosts on shares.hostid = hosts.id
17 left outer join archive_backup on backups.id = archive_backup.backup_id
18 left outer join archive on archive_backup.archive_id = archive.id
19 where backups.parts > 0 and size > 0