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