Right on. Thanks Ralf. The bconsole's query command looks into <bacula install>/scripts/query.sql file for available queries.
In bacula-5.0.2 this file is empty by default so I replaced it with the file that comes with Bacula source: <source dir>/examples/sample-query.sql For postgresql query #13 didn't work but #14 worked perfect. Now I'm looking onto expanding the file with the query Rory Campbell-Lange suggested (thanks Rory) and also with my own queries. Thanks all -- Peter On 07/27/2010 11:43 PM, Ralf Gross wrote: > Lamp Zy schrieb: >> >> I'm using bacula-5.0.2. >> >> Is there a way in bconsole to see which jobs used a particular tape? >> >> I can run "list jobmedia", save the output to a file and then grep for >> the media name but it's a lot of steps and it shows only the jobid. > > bconsole -> query > > 13: List Jobs stored on a selected MediaId > 14: List Jobs stored for a given Volume name > > I'm not sure if the standard queries are still there in 5.0.x, I > remember there was a change. > > http://www.bacula.org/5.0.x-manuals/en/main/main/New_Features_in_5_0_0.html#SECTION005181000000000000000 > > > Ralf > > ------------------------------------------------------------------------------ > The Palm PDK Hot Apps Program offers developers who use the > Plug-In Development Kit to bring their C/C++ apps to Palm for a share > of $1 Million in cash or HP Products. Visit us here for more details: > http://ad.doubleclick.net/clk;226879339;13503038;l? > http://clk.atdmt.com/CRS/go/247765532/direct/01/ > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
