*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

Reply via email to