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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
