On Fri, 12 Jan 2007, Maria McKinley wrote: > I know that when I mentioned this before, there were suggestions on how > to do this using the sql database (if I remember correctly), but it > would be nice if this were just part of the bacula interface.
You can write any custom SQL query you want and add it to query.sql This will do what you want (Arno wrote it, I just added 1 SELECT out front to make choosing pools easier than relying on memory) :List Media for a pool, ordered by LastWritten SELECT Name AS PoolName FROM Pool ; *Enter Pool name: SELECT VolumeName,VolBytes/1024/1024/1024 AS GB,LastWritten,VolStatus from Media,Pool where Media.PoolId=Pool.PoolId AND Pool.Name='%1' ORDER BY LastWritten; Append this to query.sql and then use the "query" command in a bacula console. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
