[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-users
Subject:    Re: [Bacula-users] bconsole command to display jobs on volume
From:       Lamp Zy <lampzy () gmail ! com>
Date:       2010-07-28 17:38:45
Message-ID: 4C506B25.7020500 () gmail ! com
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]