Advanced Backed Up File Names and Directories Search in Bacula bconsole – sqlquery

In addition to the searches provided by the GUIs (BWeb Enterprise and Baculum), and the search by file name of the bconsole restore command (option 2), it is also possible to use sql queries (bconsole’s sqlquery command) to find files or directories backed up by expressions, such as parts of their names.

Examples of useful queries in bconsole:

sqlquery

Search for parts in the file name

select * from file where filename like '%expression%';

Search for parts in directory names

SELECT * FROM path where path like '%expression%';

Search file part for a specific jobid

select * from file where jobid='xx' and filename like '%expression%

 

Disponível em: pt-brPortuguês (Portuguese (Brazil))enEnglishesEspañol (Spanish)

Leave a Reply