Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
40 rodolico 1 
select
2 
   device_id,
3 
   device.name Name,
4 
   site.name Site,
5 
   client.name Client
6 
from
7 
   device join device_type using (device_type_id)
8 
   join site using (site_id)
9 
   join client using (client_id)
10 
where
11 
   device.removed_date is null
12 
   and device_type.show_as_system = 'Y'
13 
   and device_id not in
14 
   (
15 
      select
16 
         distinct(device.device_id)
17 
      from
18 
         maintenance_schedule join device using (device_id)
19 
         join site using (site_id)
20 
         join client using (client_id)
21 
      where
22 
         maintenance_schedule.removed_date is null
23 
         and device.removed_date is null
24 
   );