>>>>> On Sat, 10 May 2008 11:39:56 -0400 (EDT), Jeffrey Klug said:
> 
> We're using bacula 1.36.1 and I'm having trouble finding some files in 
> the database. 
> 
> What I need is the JobId(s) of any job containing ANY file in a 
> SPECIFIC path. 
> 
> for instance.. 
> 
> doing this: 
> SELECT DISTINCT Path.PathID,Path.Path WHERE Path.Path LIKE '%Washington 
> %' LIMIT 20 
> 
> gives me: 
> 
> 114288 /mnt/monolith/fc6/SN/_library/images/Washington_on_set_pics/ 
> Disc1/CardA/ 
> 114289 /mnt/monolith/fc6/SN/_library/images/Washington_on_set_pics/ 
> Disc1/CardC/100EOS1D/ 
> 114290 /mnt/monolith/fc6/SN/_library/images/Washington_on_set_pics/ 
> Disc1/CardC/102EOS1D/ 
> 114291 /mnt/monolith/fc6/SN/_library/images/Washington_on_set_pics/ 
> Disc1/CardC/ 
> 114292 /mnt/monolith/fc6/SN/_library/images/Washington_on_set_pics/ 
> Disc1/CardB/ 
> etc... 
> 
> I've tried this: 
> SELECT DISTINCT Job.JobId,Path.PathID,Path.Path WHERE Path.Path LIKE 
> '%Washington%' AND Job.JobId=File.JobId AND Path.PathId=File.PathID 
> LIMIT 20 
> 
> but I get an empty result 
> 
> How can I find the jobid of the backup that would contain the stuff in 
> the paths listed above? 

I would expect that to work.  Maybe a retention time has expired, so the file
records have been pruned from the database?

__Martin

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2008. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users