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	-- 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;