Am 07.10.2011 19:43, schrieb John Drescher: > On Fri, Oct 7, 2011 at 12:51 PM, Jeff Shanholtz <jeffs...@shanholtz.com> > wrote: >> I appreciate that, but either you misunderstood what I'm trying to do or I >> just can't seem to make sense of the search results I'm getting as they >> apply to my issue. I did see one web page that decodes the base64 string >> from a member of this mailing list, but that operates on a single base64 >> string, not on a whole job (and even if it did, I don't know how to get >> bacula to tell me the base64 strings). >> >> I want to either get a full list of files from a job complete with file >> sizes so I can sort on the file sizes, or query for files greater than a >> certain size. I also probably should have mentioned that I'm stuck on Bacula >> v3.03 because it runs on a windows server. >> >> Could you be a little more specific on what kind of answer I'm looking for >> in the google results? >> > > I believe you need to write a query that for every file it decodes the > base64 strings. I remember this discussion although it has been a long > time so I do not remember the details. I would normally try to track > this down and help you out however I am swamped so for now this is all > I can do.. > > John
You are correct. There is a field called 'lstat' in the 'file' table that contains base64 encoded file attributes. The file size is somewhere in there. I think the function in the bacula source to decode that base64 string is called 'decode_stat' (don't know where it sits exactly; grep should help). Regards, Christian Manal ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users