Subversion Repositories computer_asset_manager_v1

select 
   device_id,
   device.name Name,
   site.name Site,
   client.name Client
from 
   device join device_type using (device_type_id)
   join site using (site_id)
   join client using (client_id)
where 
   device.removed_date is null
   and device_type.show_as_system = 'Y'
   and device_id not in
   (
      select 
         distinct(device.device_id)
      from
         maintenance_schedule join device using (device_id)
         join site using (site_id)
         join client using (client_id)
      where
         maintenance_schedule.removed_date is null
         and device.removed_date is null
   );