Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rodolico 1 
select
2 
   max(report_date) 'Last Report',
3 
   sysinfo_report.device_id 'Device ID',
4 
   device.name 'Device',
5 
   site.name 'Site',
6 
   client.name 'Client'
7 
from
8 
   sysinfo_report
9 
   join device using (device_id)
10 
   join site using (site_id)
11 
   join client using (client_id)
12 
where
13 
   device.removed_date is null
14 
   and site.name <> 'Stock'
15 
group by
16 
   device_id
17 
having
18 
   max(report_date) < date_sub( now(), interval 3 month)
19 
order by max(report_date);