"list pools" and "list volumes" will help

> *list pools
> +--------+----------+---------+---------+----------+-------------+
> | poolid | name     | numvols | maxvols | pooltype | labelformat |
> +--------+----------+---------+---------+----------+-------------+
> |      1 | Default  |       0 |       0 | Backup   | *           |
> |      2 | INC      |      35 |       0 | Backup   | *           |
> |      3 | FUL      |     129 |       0 | Backup   | *           |
> |      4 | MON      |      30 |       0 | Backup   | *           |
> |      6 | StageINC |       1 |       0 | Backup   | *           |
> +--------+----------+---------+---------+----------+-------------+
> *


> *list volumes Pool=StageINC
> +---------+------------+-----------+---------+----------+----------+--------------+---------+------+-----------+-----------+---------------------+
> | mediaid | volumename | volstatus | enabled | volbytes | volfiles | 
> volretention | recycle | slot | inchanger | mediatype | lastwritten         |
> +---------+------------+-----------+---------+----------+----------+--------------+---------+------+-----------+-----------+---------------------+
> |      78 | StageBBINC | Append    |       1 |  122,394 |        0 |  
> 315,360,000 |       1 |    0 |         1 | File      | 2007-02-08 14:44:13 |
> +---------+------------+-----------+---------+----------+----------+--------------+---------+------+-----------+-----------+---------------------+
> *   

you can also add custom queries to the bconsole by editing this file:

# cat /etc/bacula/bacula-dir.conf | grep QueryFile
   QueryFile = "/etc/bacula/scripts/query.sql"
#


Foo Bar schrieb:
> Hi,
> 
> Is there a way to see which volumes are present/known about by Bacula and
> which Pool they belong to? Or for that matter which Pools are available,
> although I can see that from looking at the configuration (but other users
> without that privilege might not). If this involves SQL statements, how do
> I add it to a command that can be executed from within bconsole?
> 
> 
>       ___________________________________________________________ 
> Want ideas for reducing your carbon footprint? Visit Yahoo! For Good  
> http://uk.promotions.yahoo.com/forgood/environment.html
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
IC3S Information, Computer und Solartechnik AG
Baekerbarg 6, 22889 Tangstedt, Germany

Telefon    +49.4109.555.121
Telefax    +49.4109.555.57
E-Mail     [EMAIL PROTECTED]
Web        http://www.ic3s.de/

Vorstand: Jan Behrmann (Vorsitzender), Stefan Fehlauer
Aufsichtsrat: Sven Niklasson (Vorsitzender)
Dresdner Bank (200 800 00), Kto. 0123 9582 00
Commerzbank (200 400 00), Kto. 8540 288
Amtsgericht Kiel HRB 7590
UST.IdNr. DE184532766

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to