Add new files

[bacula/bacula] / bacula / src / dird / query.sql

diff --git a/bacula/src/dird/query.sql b/bacula/src/dird/query.sql
index 1e9db805fa9988e9ef62b1da2a1c6f067884c72d..61ecdc4c3c29c089ae8daaf7e3c4cdfb4736fded 100644 (file)
--- a/bacula/src/dird/query.sql
+++ b/bacula/src/dird/query.sql
@@ -2,13 +2,13 @@
 SELECT  count(*) AS Jobs, sum(JobFiles) AS Files, 
  sum(JobBytes) AS Bytes, Name AS Job FROM Job GROUP BY Name;
 SELECT max(JobId) AS Jobs,sum(JobFiles) AS Files,
- sum(JobBytes) As Bytes FROM Job
+ sum(JobBytes) As Bytes FROM Job;
 #
 :List where a file is saved:
 *Enter path with trailing slash:
 *Enter filename:
 *Enter Client name:
-SELECT Job.JobId, StartTime AS JobStartTime, VolumeName, Client.Name AS ClientName
+SELECT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS ClientName
  FROM Job,File,Path,Filename,Media,JobMedia,Client
  WHERE File.JobId=Job.JobId
  AND Path.Path='%1'
@@ -25,7 +25,7 @@ SELECT Job.JobId, StartTime AS JobStartTime, VolumeName, Client.Name AS ClientNa
 *Enter path with trailing slash:
 *Enter filename:
 *Enter Client name:
-SELECT Job.JobId, StartTime AS JobStartTime, VolumeName, Client.Name AS ClientName
+SELECT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS ClientName
  FROM Job,File,Path,Filename,Media,JobMedia,Client
  WHERE File.JobId=Job.JobId
  AND Path.Path='%1'
@@ -41,13 +41,35 @@ SELECT Job.JobId, StartTime AS JobStartTime, VolumeName, Client.Name AS ClientNa
 :List last 20 Full Backups for a Client:
 *Enter Client name:
 Select Job.JobId,Client.Name as Client,StartTime,JobFiles,JobBytes,
-JobMedia.StartFile as VolFile, VolumeName
+JobMedia.StartFile as VolFile,VolumeName
  FROM Client,Job,JobMedia,Media
  WHERE Client.Name='%1'
  AND Client.ClientId=Job.ClientId
  AND Level='F' AND JobStatus='T'
  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
- ORDER BY JobId DESC LIMIT 20;
+ ORDER BY Job.StartTime DESC LIMIT 20;
+#
+:List all backups for a Client after a specified time
+*Enter Client Name:
+*Enter time in YYYY-MM-DD HH:MM:SS format:
+Select Job.JobId,Client.Name as Client,Level,StartTime,JobFiles,JobBytes,VolumeName
+  FROM Client,Job,JobMedia,Media
+  WHERE Client.Name='%1'
+  AND Client.ClientId=Job.ClientId
+  AND JobStatus='T'
+  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
+  AND Job.StartTime >= '%2'
+  ORDER BY Job.StartTime;
+#
+:List all backups for a Client
+*Enter Client Name:
+Select Job.JobId,Client.Name as Client,Level,StartTime,JobFiles,JobBytes,VolumeName
+  FROM Client,Job,JobMedia,Media
+  WHERE Client.Name='%1'
+  AND Client.ClientId=Job.ClientId
+  AND JobStatus='T'
+  AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
+  ORDER BY Job.StartTime;
 #
 :List Volume Attributes for a selected Volume:
 *Enter Volume name:
@@ -126,7 +148,7 @@ SELECT Job.JobId as JobId, Client.Name as Client,
  FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
  AND JobStatus='T' AND Job.JobId=File.JobId
  AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
- AND Filename.Name='%1' ORDER BY Job.JobId LIMIT 20;
+ AND Filename.Name='%1' ORDER BY Job.StartTime LIMIT 20;
 #
 :List total files/bytes by Job:
 SELECT count(*) AS Jobs, sum(JobFiles) AS Files,
@@ -140,3 +162,11 @@ SELECT count(*) AS Jobs, sum(JobFiles) AS Files,
  WHERE JobMedia.JobId=Job.JobId
  AND JobMedia.MediaId=Media.MediaId
  GROUP by VolumeName;  
+#
+:List Files for a selected JobId:
+*Enter JobId:
+SELECT Path.Path,Filename.Name FROM File,
+ Filename,Path WHERE File.JobId=%1 
+ AND Filename.FilenameId=File.FilenameId 
+ AND Path.PathId=File.PathId ORDER BY
+ Path.Path,Filename.Name;