display archives and archvies without backup parts

[BackupPC.git] / sql / xx_backups_without_backup_parts.sql

diff --git a/sql/xx_backups_without_backup_parts.sql b/sql/xx_backups_without_backup_parts.sql
new file mode 100644 (file)
index 0000000..15569f0
--- /dev/null
+++ b/sql/xx_backups_without_backup_parts.sql
@@ -0,0 +1,11 @@
+select
+       hosts.name,
+       shares.name,
+       backups.num,
+       date::abstime
+from backups
+       join hosts on hosts.id = hostid
+       join shares on shares.id = shareid
+where backups.id not in (select backup_id from backup_parts) and inc_size != -1
+order by hosts.name, shares.name ;
+