From 36ebc4562ca730f1d4eca96adcb4b7111458ea62 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 27 May 2022 09:48:00 +0200 Subject: [PATCH] Fix query SQL provided in sample-query.sql Thanks to Giuseppe Comae --- bacula/examples/sample-query.sql | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/bacula/examples/sample-query.sql b/bacula/examples/sample-query.sql index 7dfcbd633..07fffe231 100644 --- a/bacula/examples/sample-query.sql +++ b/bacula/examples/sample-query.sql @@ -153,10 +153,12 @@ SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,Name AS Jo # 11 :List total files/bytes by Volume SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,VolumeName - FROM Job,JobMedia,Media - WHERE JobMedia.JobId=Job.JobId - AND JobMedia.MediaId=Media.MediaId - GROUP by 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; # 12 :List Files for a selected JobId *Enter JobId: -- 2.47.3