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.

-- 
John Wallach
Systems Administrator
PGP Fingerprint: C089 65CA 1F30 8A02 86C5 6BC3 59E1 ACE4 F8B4 28DB
Democracy Now!
www.democracynow.org

------------------------------------------------------------------------------
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