Hello Phil and Giuseppe,
Thanks for the fix and the review, I will fix the current query file.
It will be included in the next beta 11.3.4 that is almost ready.
Best Regards,
Eric
On 25.05.22 21:24, Phil Stracchino wrote:
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.
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
