On Aug 6, 2014, at 12:11 PM, John Wallach <john AT democracynow DOT org> wrote:

> Greetings,
> 
> Our ancient autoloader decided to render a particular tape inoperable.
> Before my time jobs were run that spanned multiple volumes, the
> destroyed tape was in one such job.
> 
> I cannot figure out how to find the files associated with the specific
> media. Here's a query that I thought would work but returns the same for
> any media id provided:
> SELECT t3.Path, t1.Name FROM Filename AS t1 JOIN File as t2 ON
> t1.FilenameId = t2.FilenameId JOIN Path as t3 ON t3.PathId = t2.PathId
> JOIN JobMedia as t4 ON  t2.JobId = t4.JobId WHERE t4.MediaId = 475 AND
> t2.JobId = 8876 LIMIT 10;
> 
> Any help would be much appreciated.

Does this help?

http://dan.langille.org/2009/08/28/what-jobs-are-on-these-tapes/

— 
Dan Langille

signature.asc
Description: Message signed with OpenPGP using GPGMail

------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls. 
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk

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