From bd5bfcc377663feb7f77d6e2c3b1b66f5aaab7fa Mon Sep 17 00:00:00 2001 From: Martin Simmons Date: Mon, 30 Nov 2020 10:36:50 +0100 Subject: [PATCH] Fix org#2471 About deleted files are listed as being present in an accurate backup by various sample queries --- bacula/examples/sample-query.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/bacula/examples/sample-query.sql b/bacula/examples/sample-query.sql index 40e8b444c..1eac8c5f7 100644 --- a/bacula/examples/sample-query.sql +++ b/bacula/examples/sample-query.sql @@ -20,7 +20,8 @@ SELECT DISTINCT Job.JobId as JobId, Client.Name as Client, FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId AND JobStatus IN ('T','W') AND Job.JobId=File.JobId AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId - AND Filename.Name='%1' + AND Filename.Name='%1' + AND File.FileIndex > 0 ORDER BY Job.StartTime LIMIT 20; # 2 :List where the most recent copies of a file are saved @@ -30,6 +31,7 @@ SELECT DISTINCT Job.JobId as JobId, Client.Name as Client, SELECT DISTINCT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS ClientName FROM Job,File,Path,Filename,Media,JobMedia,Client WHERE File.JobId=Job.JobId + AND File.FileIndex > 0 AND Path.Path='%1' AND Filename.Name='%2' AND Client.Name='%3' @@ -160,6 +162,7 @@ SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,VolumeName :List Files for a selected JobId *Enter JobId: SELECT Path.Path,Filename.Name FROM File,Filename,Path WHERE File.JobId=%1 + AND File.FileIndex > 0 AND Filename.FilenameId=File.FilenameId AND Path.PathId=File.PathId ORDER BY Path.Path,Filename.Name; -- 2.47.3