Hello,
We specifically implemented the Query command so that you could write
your own queries to the database. Unfortunately SQL database backends
(MySQL, MariaDB, and PostgreSQL) all use different SQL commands in many
cases, so you need to write your queries for a particular backend.
Bottom line: using a query command you can customize database queries to
suit your particular needs.
Best regards,
Kern
On 22/09/2017 15:04, Christoph Litauer wrote:
Dear bacula users,
using bacula for many years without problems now. Great software!
One little thing would be nice:
In bconsole, querying e.g. "List alle backups for a client" results in
+---------+-----------+------------------------+-------+---------------------+----------+---------------+------------+
| jobid | client | fileset | level | starttime |
jobfiles | jobbytes | volumename |
+---------+-----------+------------------------+-------+---------------------+----------+---------------+------------+
| 821,494 | printhost | client files-to-backup | F | 2016-11-19 00:10:53 |
222,727 | 5,945,291,349 | LTO6-012 |
As you can see, all numbers are printed using thousands separators. I think
this is independent on the current locale (tried with C and en).
These numbers cannot be reused (by copy/paste) within bconsole or some other
scripts without reformatting.
Selecting information using psql seems to ommit those separators.
Would be nice, if bconsole didn't print separators within numbers.
--
Kind regards
Christoph
_________________________________________
Uni Koblenz, Computing Centre, Office A 022
Postfach 201602, 56016 Koblenz
Fon: +49 261 287-1311, Fax: -100 1311
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
