Subversion Repositories computer_asset_manager_v1

Rev

Rev 1 | Rev 50 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1 Rev 38
Line 106... Line 106...
106 
from backups join backups_run using (backups_id)
 106 
from backups join backups_run using (backups_id)
107 
     join device using (device_id)
 107 
     join device using (device_id)
108 
where device.device_id = <device_id>
 108 
where device.device_id = <device_id>
109 
group by device.name, concat(year(backups_run.start_time), \'-\', month(backups_run.start_time))
 109 
group by device.name, concat(year(backups_run.start_time), \'-\', month(backups_run.start_time))
110 
order by device.name, concat(year(backups_run.start_time), \'-\', month(backups_run.start_time))','device_id++Computer++select device_id,device.name from device where device_id in (select device_id from backups) order by device.name++select name from device where device_id = <value>');
 110 
order by device.name, concat(year(backups_run.start_time), \'-\', month(backups_run.start_time))','device_id++Computer++select device_id,device.name from device where device_id in (select device_id from backups) order by device.name++select name from device where device_id = <value>');
- 
 
 111 
 
- 
 
 112 
/* last <count> backups recorded */
- 
 
 113 
 
- 
 
 114 
insert into report ( name, query, parameters,screen_report ) values ('New Report','select
- 
 
 115 
   backups_run.start_time Started,
- 
 
 116 
   backups_run.end_time Ended,
- 
 
 117 
   backups_run.version Version,
- 
 
 118 
   format(backups_run.files_count,0) Files,
- 
 
 119 
   format(backups_run.files_size/1024/1024,0) \'Size (M)\',
- 
 
 120 
   format(backups_run.transferred_count,0) Transfer,
- 
 
 121 
   format(backups_run.skipped,0) Skipped,
- 
 
 122 
   format(backups_run.files_deleted,0) Deleted,
- 
 
 123 
   format(backups_run.data_sent/1024/1024,2) \'MB Out\',
- 
 
 124 
   format(backups_run.data_received/1024/1024,2) \'MB In\',
- 
 
 125 
   backups_run.disk_used Disk
- 
 
 126 
from
- 
 
 127 
   backups_run join backups using (backups_id)
- 
 
 128 
where
- 
 
 129 
   backups.device_id = <device_id>
- 
 
 130 
order by
- 
 
 131 
   backups_run.report_date desc
- 
 
 132 
limit <count>','device_id++Device ID++++
- 
 
 133 
count++Number of Reports++++',1);