[Bacula-users] querying database for filenames by checksum?

[<mar...@up...>]

I've got a sudden need to determine whether there's a copy of a particular file
anywhere on our systems, even if it's been renamed. I really don't want to do
terrible things with shell scripts and "find" and "md5sum" and so forth across
~9TB of data (on ~15 servers).



It was absolutely terrific to be able to query the Bacula database to search 
for the file by name and get a quick answer. Is there any similar way to query 
the database for a single filename (a fully qualified host:/path/to/file), and
have the query return all entries where the checksum matches the specified 
file, regardless of their name or location?

I'd be very grateful if anyone could contribute a snippet of SQL...

Thanks,

Mark

----
Mark Bergman                      mar...@up...
System Administrator
Section of Biomedical Image Analysis             215-662-7310
Department of Radiology,           University of Pennsylvania

http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upenn.edu



The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.