View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000191bareos-coredirectorpublic2013-06-19 17:152013-07-05 16:31
Reporteruser12Assigned Tomaik  
PrioritynormalSeverityfeatureReproducibilityalways
Status closedResolutionwon't fix 
Product Version12.4.4 
Summary0000191: Obtain sum of bytes in human readable format with bconsole -h or generally comma separated listing like sum of files
DescriptionIt is quite enoying to read sum of bytes in bconsole:
+--------+-------------+----------------+
| jobs | files | bytes |
+--------+-------------+----------------+
| 19,210 | 155,659,320 | 27587643684706 |
+--------+-------------+----------------+

Steps To Reproducebconsole
*list jobtotals
Additional InformationHow about always in GBs?

bareos=# SELECT count(*) AS Jobs,sum(JobFiles) AS Files,ROUND(sum(JobBytes)/1024/1024/1024,3) As GigaBytes FROM Job;
 jobs | files | gigabytes
-------+-----------+-----------
 19210 | 155659320 | 25692.995
(1 Zeile)

or comma separated in Format '999,999...' like sum of files: 155,659,320?
TagsNo tags attached.

Activities

joergs

joergs

2013-06-21 17:00

developer   ~0000472

this will be a lot of work, we leave it open as feature request, but it will not be done soon.

user12

2013-06-21 17:08

  ~0000474

There are commands, which does that formating already like
list job=erol
| jobid | name | starttime | type | level | jobfiles | jobbytes | jobstatus |
| 121,572 | erol | 2013-06-21 10:33:03 | B | D | 963 | 202,553,011 | T
maik

maik

2013-07-05 16:30

administrator   ~0000499

Marco: could be done by stored procedures but not with sqlite, problematic because queries are generic for now.

Too much effort for small benefit. If someone really wants it, we are open for suggestions and patches.

Issue History

Date Modified Username Field Change
2013-06-19 17:15 user12 New Issue
2013-06-21 17:00 joergs Note Added: 0000472
2013-06-21 17:08 user12 Note Added: 0000474
2013-07-05 16:30 maik Note Added: 0000499
2013-07-05 16:30 maik Status new => closed
2013-07-05 16:31 maik Assigned To => maik
2013-07-05 16:31 maik Resolution open => won't fix