"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