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 [EMAIL PROTECTED] 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. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
