[Bacula-users] Fwd: query needed for 1.36.1

Help please!

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?

JeffK

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users