On 10/22/10 14:07, mark.bergman AT uphs.upenn DOT edu wrote:
> The pithy ruminations from Phil Stracchino <alaric AT metrocast DOT net> on 
> "Re: [Bacula-users] Searching for files" were:
> 
> => On 10/22/10 02:47, ladolf wrote:
> => > Maybe anyone knows how to query the bacula database directly to get
> => > search result for a file.
> => 
> => At the simplest possible level: start up bconsole, use the SQL query
> => function, and enter this query:
> 
> Wow.
> 
> Could you please re-read this, and consider whether this is really the 
> "simplest possible level"? I think I understand what you mean, but it's far 
> from "simple".

The OP asked for a way to directly query the Bacula DB for a file that
he can only remember part of the filename of.  That short one-liner
query in the Filename table really is the simplest way to retrieve full
filenames case-insensitively matching the part he remembers, and the SQL
Query function in bconsole is the simplest way to execute it for someone
not proficient in SQL.



-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
         Renaissance Man, Unix ronin, Perl hacker, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users