[Bacula-users] SQL query

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