# This file contains sample queries that you can possibly use in
# your query.sql file. However, please note that these examples
# are not supported. They may or may not work -- in fact, they may
-# work with one SQL engine and not another.
+# work with one SQL engine and not another. As a consequence,
+# please do not submit bug reports on either query.sql or
+# sample-query.sql
#
# If you find that they work for MySQL and not for PostgreSQL,
# then please send us a whole new file corrected for PostgreSQL
-# and we will post it here for everyone to use.
+# and we will post it in the examples directory for everyone
+# to use.
#
# 1
AND InChanger=0
AND ((VolStatus='Purged') OR (VolStatus='Append') OR (VolStatus='Recycle'))
ORDER BY VolMounts ASC, Pool.Name ASC, VolumeName ASC
+# 18
+:List Volumes by Volume:
+SELECT VolumeName, Job.JobId as JobID, Job.Name as JobName, Job.StartTime as
+Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes
+ FROM Job,JobMedia,Media
+ WHERE JobMedia.JobId=Job.JobId
+ AND JobMedia.MediaId=Media.MediaId
+ GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime
+ ORDER by VolumeName;
+# 19
+:List Volumes by Jobs:
+SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as
+Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes
+ FROM Job,JobMedia,Media
+ WHERE JobMedia.JobId=Job.JobId
+ AND JobMedia.MediaId=Media.MediaId
+ GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime
+ ORDER by JobName, Start;
+# 20
+:List Volumes for a jobname:
+*Enter Job name:
+SELECT Job.Name as JobName, Job.JobId as JobID, VolumeName, Job.StartTime as
+Start, sum(JobFiles) AS Files,sum(JobBytes) AS Bytes
+ FROM Job,JobMedia,Media
+ WHERE Job.Name='%1'
+ AND JobMedia.JobId=Job.JobId
+ AND JobMedia.MediaId=Media.MediaId
+ GROUP by VolumeName, Job.JobID, Job.Name, Job.StartTime
+ ORDER by JobName, Start;
+