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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
