On 5/25/22 13:23, SO Giuseppe - COMAE via Bacula-users wrote:
SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS
Bytes,VolumeName
FROM (SELECT DISTINCT Jobmedia.JobId, JobFiles, JobBytes, VolumeName
FROM Job,JobMedia,Media
WHERE JobMedia.JobId=Job.JobId
AND JobMedia.MediaId=Media.MediaId) AS f
GROUP BY VolumeName
ORDER BY VolumeName;
MySQL 127.0.0.1> SELECT count(*) AS Jobs,sum(JobFiles) AS
Files,sum(JobBytes) AS Bytes,VolumeName
-> FROM (SELECT DISTINCT Jobmedia.JobId, JobFiles, JobBytes, VolumeName
-> FROM Job,JobMedia,Media
-> WHERE JobMedia.JobId=Job.JobId
-> AND JobMedia.MediaId=Media.MediaId) AS f
-> GROUP BY VolumeName
-> ORDER BY VolumeName;
ERROR 1054 (42S22): Unknown column 'Jobmedia.JobId' in 'field list'
Straightforward typo in line 3. You have Jobmedia instead of JobMedia.
With the typo fixed, yes, this yields much more reasonable and
correct-looking results.
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users