Hi all,
I try to query MySQL to obtain all the date of backup for a file.
I used this but have only the last backup :
:List all backup for a File with date :
*Enter Client :
*Enter Filename (no path) :
SELECT Client.Name as Client,
Path.Path,Filename.Name, Job.JobId as JobId,
StartTime
FROM Client,Job,File,Filename,Path
WHERE Client.ClientId=Job.ClientId
AND Job.JobId=File.JobId
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND Client.Name='%1'
AND Filename.Name='%2'
ORDER BY Path.Path;
Any help appreciated
Best regards
--
David Dumortier
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|