[Bacula-users] From what jobs was this file backed up?

Just in case it helps:

Today I was trying to find a file named ca.crt.  I didn't know the 
hostname, the job, or the path.  I worked this way:

SELECT DISTINCT P.path, FN.name, J.name, F.md5
   FROM path P, file F, job J, filename FN
  WHERE P.path LIKE '%/easy-rsa/%'
    AND P.pathid      = F.pathid
    AND F.jobid       = J.jobid
    AND FN.filenameid = F.filenameid
ORDER BY 1, 2, 3;

I knew that the ca.crt file would be in a sub directory of easy-rsa.  I 
started with the above query and eventually found the right directory...

-- 
Dan Langille - http://langille.org/

------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users