-:List Job totals:
-SELECT count(*) AS Jobs,sum(JobFiles) AS Files,
- sum(JobBytes) AS Bytes,Name AS Job
- FROM Job
- GROUP BY Name;
-SELECT max(JobId) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) As Bytes
- FROM Job;
-# 2
-:List up to 20 places where a File is saved regardless of the directory: