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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
