Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
29 rodolico 1 
select
2 
   year.device_id,
3 
   week.device_id,
4 
   device.name
5 
from
6 
   (select distinct(device_id) from sysinfo_report where report_date > 20150101 ) year
7 
   left join
8 
   (select distinct(device_id) from sysinfo_report where report_date > 20160607 ) week
9 
   using (device_id)
10 
   join device using (device_id)
11 
where week.device_id is null;