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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users