Hi, Martin Simmons a écrit : >>>>>> 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
Ok I'm going to tweak some parameters and see. Thank you for reply. Best regards -- David Dumortier ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
