>>>>> On Wed, 13 Jan 2010 14:18:18 +0100, David Dumortier said: > Importance: Normal > > 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;
That should work. Maybe your catalog has been pruned, so the file records are no longer there? __Martin ------------------------------------------------------------------------------ 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