/[BackupPC]/trunk/sql/xx_display_archive.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /trunk/sql/xx_display_archive.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 366 - (hide annotations)
Thu Jan 25 09:25:23 2007 UTC (17 years, 4 months ago) by dpavlin
File size: 304 byte(s)
display archives and archvies without backup parts

1 dpavlin 366 select
2     hosts.name as host,
3     shares.name,
4     backups.num as share,
5     inc_size,
6     inc_deleted,
7     parts
8     from archive_backup
9     join backups on backups.id = backup_id
10     join shares on shares.id = shareid
11     join hosts on hosts.id = shares.hostid
12     where archive_id = 21 order by hosts.name, shares.name, backups.num ;
13    

  ViewVC Help
Powered by ViewVC 1.1.26