Subversion Repositories computer_asset_manager_v1

/* Modify the client name and begin date in the where clause */
select 
   date( backups_run.report_date ) 'Report Date',
   backups_run.start_time 'Start Time',
   backups_run.end_time 'End Time',
   backups_run.files_count 'Total Files',
   round( backups_run.files_size/1024/1024,2) 'Total Size (M)',
   backups_run.transferred_count 'Files Transferred',
   round( backups_run.transferred_size/1024/1024,2) 'Size Transferred (M)',
   backups_run.files_deleted 'Files Deleted',
   backups_run.skipped 'Skipped',
   round( backups_run.data_sent/1024/1024,2) 'Data Sent (M)'
from 
   backups_run join backups using(backups_id)
   join device using (device_id)
   join site using (site_id)
   join client using (client_id)
where
   client.name like '%Roome%'
   and backups_run.report_date > 20170101;