Subversion Repositories computer_asset_manager_v1

select 
   distinct(device.name),
   site.name,
   client.name
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
order by 
   client.name,
   site.name,
   device.name;