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
