Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 38 Rev 50
Line 109... Line 109...
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 
 
 111 
 
112 
/* last <count> backups recorded */
 112 
/* last <count> backups recorded */
113 
 
 113 
 
114 
insert into report ( name, query, parameters,screen_report ) values ('New Report','select
 114 
insert into report ( name, query, parameters ) values ('Backup History','select
115 
   backups_run.start_time Started,
 115 
   backups_run.start_time Started,
116 
   backups_run.end_time Ended,
 116 
   backups_run.end_time Ended,
117 
   backups_run.version Version,
 117 
   backups_run.version Version,
118 
   format(backups_run.files_count,0) Files,
 118 
   format(backups_run.files_count,0) Files,
119 
   format(backups_run.files_size/1024/1024,0) \'Size (M)\',
 119 
   format(backups_run.files_size/1024/1024,0) \'Size (M)\',
Line 128... Line 128...
128 
where
 128 
where
129 
   backups.device_id = <device_id>
 129 
   backups.device_id = <device_id>
130 
order by
 130 
order by
131 
   backups_run.report_date desc
 131 
   backups_run.report_date desc
132 
limit <count>','device_id++Device ID++++
 132 
limit <count>','device_id++Device ID++++
133 
count++Number of Reports++++',1);
 133 
count++Number of Reports++++');