Hi, I forgot to mention that this works with MySQL and is not exactly tuned for anything. It just did what I thought you wanted when I tried it here.
Arno On 9/1/2006 10:48 PM, Arno Lehmann wrote: > Hi, > > On 9/1/2006 10:19 PM, Maria McKinley wrote: > >>Hello, >> >>I couldn't find anything in the documentation, so thought I'd ask. Is >>there anyway to get bacula to list the volumes in a pool in order of >>date LastWritten instead of MediaID? > > > Add the following to your query.sql: > > # 21 > :List Media for a pool, ordered by LastWritten > *Enter Pool name: > SELECT VolumeName,VolBytes/1024/1024/1024 AS GB,LastWritten from > Media,Pool where Media.PoolId=Pool.PoolId AND Pool.Name='%1' ORDER BY > LastWritten; > > Add fields to taste ;-) > > Arno > > >>thanks a bunch, >>Maria >> >>------------------------------------------------------------------------- >>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 >>[email protected] >>https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
