trunk/sql/backups.sql

-- report number of files in each backup

select
        shares.name,
        hosts.name,
        backupnum,
        count(*)
from files
join shares on shareid=shares.id
join hosts on hostid = hosts.id
group by shares.name, hosts.name, backupnum
order by hosts.name, shares.name, backupnum;
1	dpavlin	75	-- report number of files in each backup
2
3			select
4			shares.name,
5			hosts.name,
6			backupnum,
7			count(*)
8			from files
9			join shares on shareid=shares.id
10			join hosts on hostid = hosts.id
11			group by shares.name, hosts.name, backupnum
12			order by hosts.name, shares.name, backupnum;