*query Available queries: 1: List up to 40 places where a File is saved regardless of the directory 2: List places where a File from a given Client is saved regardless of the directory and case 3: List where the most recent copies of a file are saved 4: List last 20 Full Backups for a Client 5: List all backups for a Client after a specified time 6: List all backups for a Client 7: List Volume Attributes for a selected Volume 8: List Volumes used by selected JobId 9: List Volumes to Restore All Files 10: List Pool Attributes for a selected Pool 11: List total files/bytes by Job 12: List total files/bytes by Volume 13: List Files for a selected JobId 14: List Jobs stored in a selected MediaId 15: List Jobs stored for a given Volume name 16: List Volumes Bacula thinks are in changer JBGS 17: List Volumes Bacula thinks are in changer JBBB 18: List Volumes likely to need replacement from age or errors 19: List Volumes Bacula thinks should be removed from changer 20: List Volumes Bacula thinks are eligible for the changer Choose a query (1-20): *
:) Foo Bar schrieb: > --- Thomas Glatthor <[EMAIL PROTECTED]> wrote: > > >> "list pools" and "list volumes" will help >> > > Ah, thanks, I must be blind :) > > >> 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" >> > > How do you call the SQL statements from this? > > > ___________________________________________________________ > 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 > ------------------------------------------------------------------------- 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