display archives and archvies without backup parts

[BackupPC.git] / sql / xx_display_archive.sql

diff --git a/sql/xx_display_archive.sql b/sql/xx_display_archive.sql
new file mode 100644 (file)
index 0000000..7dfb43f
--- /dev/null
+++ b/sql/xx_display_archive.sql
@@ -0,0 +1,13 @@
+select
+       hosts.name as host,
+       shares.name,
+       backups.num as share,
+       inc_size,
+       inc_deleted,
+       parts
+from archive_backup
+       join backups on backups.id = backup_id
+       join shares on shares.id = shareid
+       join hosts on hosts.id = shares.hostid
+where archive_id = 21 order by hosts.name, shares.name, backups.num ;
+