Re: [Bacula-users] Fwd: query needed for 1.36.1
2008-05-12 15:19:39
>>>>> 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
|
|
|