| 82 |
rodolico |
1 |
/* Modify the client name and begin date in the where clause */
|
|
|
2 |
select
|
|
|
3 |
date( backups_run.report_date ) 'Report Date',
|
|
|
4 |
backups_run.start_time 'Start Time',
|
|
|
5 |
backups_run.end_time 'End Time',
|
|
|
6 |
backups_run.files_count 'Total Files',
|
|
|
7 |
round( backups_run.files_size/1024/1024,2) 'Total Size (M)',
|
|
|
8 |
backups_run.transferred_count 'Files Transferred',
|
|
|
9 |
round( backups_run.transferred_size/1024/1024,2) 'Size Transferred (M)',
|
|
|
10 |
backups_run.files_deleted 'Files Deleted',
|
|
|
11 |
backups_run.skipped 'Skipped',
|
|
|
12 |
round( backups_run.data_sent/1024/1024,2) 'Data Sent (M)'
|
|
|
13 |
from
|
|
|
14 |
backups_run join backups using(backups_id)
|
|
|
15 |
join device using (device_id)
|
|
|
16 |
join site using (site_id)
|
|
|
17 |
join client using (client_id)
|
|
|
18 |
where
|
|
|
19 |
client.name like '%Roome%'
|
|
|
20 |
and backups_run.report_date > 20170101;
|