On Aug 6, 2014, at 12:11 PM, John Wallach <j...@democracynow.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
