17.10.2009 17:41, Terry L. Inzauro kirjoitti:
A simple query will return those
SELECT SUM(JobFiles) AS JobFilesSum, SUM(JobBytes) AS JobBytesSum
FROM Job ;
but that is not much of interest, I guess.
--
http://www.iki.fi/jarif/
Ships are safe in harbor, but they were never meant to stay there.
Ok. Can the SQLPlus client be used with mysql? Is it freely available?
Absolutely not. SQL*Plus and Oracle may be downloadable from Oracle, but
Bacula does not support Oracle yet (an ODBC driver for Bacula has been a
dream in my mind for long).
But SQL*Plus can't be used with MySQL. Dunno what future brings, as
Oracle now owns MySQL, but I would not count on it.
Just thrownign this out there:
Could the limitation of the mysql client be worked around by running a few
different queries and then appending the results
to one another? Basically run two queries, then SUN() the results of each
query, and then combine the results to produce a
report that contains both of the individual reports information?
I have not done any sql queries for Bacula, but I think it is possible.
I think a query in Bacula may be composed from multiple SQL statements.
Also, I guess an alternative would be to run the output through a perl script
that sums the appropriate column but its not a
very clean solution.
Indeed. It is doable.
--
http://www.iki.fi/jarif/
An honest tale speeds best being plainly told.
-- William Shakespeare, "Henry VI"
pgpmDWx3bAScH.pgp
Description: PGP signature
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
| 