Hello,
In the bconsole restore options list, there is this entry:
2: List Jobs where a given File is saved
But it seems strange to me that there isn't the equivalent option for
'List Jobs where a given Directory is saved'.
I guess the query would be something like this:
SELECT DISTINCT Job.JobId as JobId,
Path.Path,
StartTime,Type as JobType,JobStatus,JobFiles,JobBytes
FROM Client,Job,File,Path WHERE Client.Name='<clientname>'
AND Client.ClientId=Job.ClientId
AND Job.JobId=File.JobId AND File.FileIndex > 0
AND Path.PathId=File.PathId
AND Path.Path='<directory>'
ORDER BY StartTime DESC LIMIT 20;
Also, the existing option can only search for filenames without the path.
It says: "Enter Filename (no path):"
What I would find most useful would be an option to search for a specific full
path name:
SELECT Job.JobId as JobId,
CONCAT(Path.Path,Filename.Name) as Name,
StartTime,Type as JobType,JobStatus,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.Name='<clientname>'
AND Client.ClientId=Job.ClientId
AND Job.JobId=File.JobId AND File.FileIndex > 0
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND Path.Path='<directory>'
AND Filename.Name='<file>'
ORDER BY StartTime DESC LIMIT 20;
Admittedly, there is option 4, where I could enter these myself.
4: Enter SQL list command
But is there a good reason for not including these options?
------------------------------------------------------------------------------
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
