I searched the archive for an answer to this question. I found it asked
but never answered:
The bconsole command 'list jobs' gives me a list of runs from all jobs.
I want to narrow it to all job runs from a particular job. The bconsole
doc under "list" seems to imply that would be done with:
list job=My-Job
This doesn't work (I am running mysql under Gentoo Linux). I tried every
combination that I could think of-- quotes, tics, etc. to no avail.
'list jobs' works fine but is just painfully cluttered. I even guessed at:
list jobs job=My-Job
and all the combinations of quotes, tics etc. (jobid= works fine too)
Alas, my suspicion is this query just doesn't function. Since I believe
that this is a very fundemental query, and since out of the corner of my
eye while searching the archives for an answer I seem to have noticed
questions about formulating sql queries against the Bacula database
tables, I have a broader question in regard to what I should expect in
diving into Bacula:
Should I expect that the Bacula development community is focusing on the
more critical areas of this highly complex and powerful opensource
project? Should I bite the bullet, and bone up on my sql skills on the
assumption that these relatively benign (but from a practical
perspective of a Bacula implimentation, important) queries may not be
fully debugged and tested as of yet? Should I assume that I will "become
one" with the product more quickly if I just accept this, and learn to
write my own queries as needed?
I am really hoping the answer is "no." But I can understand if it is
"yes," as I certainly haven't been the one contributing to this
monumental project :) (Although, if it is "yes" I will confess to being
a little disappointed as I was hoping query writing would only come up
in future fine-tuning of my implimentation).
If this is the case, then I am just wondering where I should start. I
haven't really tried to delve into the source although I have taken a
peek at "query.sql." What is not clear to me is where all the queries
forming the 'list' commands are hiding. Do I need to get my hands on
some source to get started on examples of useful queries? Should the
task be to simply tack new queries onto query.sql as I need them?
Or am I getting paranoid, all documented queries work great, and I am
just being clueless, having missed the obvious (which wouldn't be the
first time)? :)
Thanks in advance for any help and advice.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
