Parent Directory | Revision Log
added some useful SQL examples. They are lightly commented within each file.
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; |
ViewVC Help | |
Powered by ViewVC 1.1.26 |