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