bacula-11.0.5/examples/sample-query.sql

32  FROM Job,File,Path,Filename,Media,JobMedia,Client
40  AND JobMedia.JobId=Job.JobId
41  AND JobMedia.MediaId=Media.MediaId
48   JobMedia.StartFile as VolFile,VolumeName
49  FROM Client,Job,JobMedia,Media
53  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
60  FROM Client,Job,JobMedia,Media
64  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
73  FROM Client,Job,JobMedia,Media,FileSet
77  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
90  FROM Job,JobMedia,Media
92  AND Job.JobId=JobMedia.JobId
93  AND JobMedia.MediaId=Media.MediaId;
117   StartTime,VolumeName,JobMedia.StartFile,VolSessionId,VolSessionTime
118  FROM Client,Job,JobMedia,Media WHERE Client.Name='%1'
121  AND JobMedia.JobId=Job.JobId
122  AND JobMedia.MediaId=Media.MediaId
126   JobMedia.StartFile,Job.VolSessionId,Job.VolSessionTime
127  FROM temp,Job,JobMedia,Media WHERE temp.JobId=Job.JobId
129  AND JobMedia.JobId=Job.JobId
130  AND JobMedia.MediaId=Media.MediaId;
133   Job.Level,JobMedia.StartFile,Job.VolSessionId,Job.VolSessionTime
134  FROM Job,temp,JobMedia,Media
138  AND JobMedia.JobId=Job.JobId
139  AND JobMedia.MediaId=Media.MediaId;
157  FROM Job,JobMedia,Media
158  WHERE JobMedia.JobId=Job.JobId
159  AND JobMedia.MediaId=Media.MediaId
174  FROM JobMedia,Job
175  WHERE JobMedia.JobId=Job.JobId
176  AND JobMedia.MediaId=%1
184  FROM Media,JobMedia,Job
186  AND Media.MediaId=JobMedia.MediaId
187  AND JobMedia.JobId=Job.JobId
220  FROM Job,JobMedia,Media
221  WHERE JobMedia.JobId=Job.JobId
222  AND JobMedia.MediaId=Media.MediaId
229  FROM Job,JobMedia,Media
230  WHERE JobMedia.JobId=Job.JobId
231  AND JobMedia.MediaId=Media.MediaId
239  FROM Job,JobMedia,Media
241  AND JobMedia.JobId=Job.JobId
242  AND JobMedia.MediaId=Media.MediaId