On Sat, Aug 19, 2006 at 12:28:59AM -0700, Jo Rhett wrote: > From: Jo Rhett <[EMAIL PROTECTED]> > To: bacula-users@lists.sourceforge.net > Date: Sat, 19 Aug 2006 00:28:59 -0700 > Subject: [Bacula-users] list of jobs in a given volume? > > So I've poked around all day trying to track down an overly large backup, > and I've realized something. I can't seem to find any useful way to get a > list of jobs that are stored in a given volume / media. Even using direct > SQL, I can't seem to find a join command that will say > > Daily-0019 contains jobs client1, client2, etc. > > I'm certain there has to be a way, but I can't seem to find it. >
Have you tried "query #15", "List Jobs stored for a given Volume name:", or are you looking for a list regardless of volume name? Some shell scripting should get you going, like get a list of all volumes where inchanger=1 (if you want), then do a query #15 for each of them. Cheers, uwe -- Uwe Schuerkamp, NIONEX GmbH (http://www.nionex.com/) [EMAIL PROTECTED] Tel: +49 (0)5241 / 80 10 66 FAX: / 806 23 38 Avenwedder Str. 55, D-33311 Guetersloh, Germany GnuPG KeyID: 5887047D, Fingerprint: 2E1320229A3F63 7F676FE9B1A836A461 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users