Subversion Repositories computer_asset_manager_v1

select 
   count(*) tasks,
   device.name device,
   site.name site,
   client.name client,
   email tech
from
   maintenance_schedule join device using (device_id)
   join site using (site_id)
   join client using (client_id)
   join login using (login_id)
where
   maintenance_schedule.removed_date is null
   and device.removed_date is null
group by
   device.name,
   site.name,
   client.name,
   email
;