Subversion Repositories computer_asset_manager_v1

/* get maintenance tasks and machines per user */
select login.email, count(*) tasks,count(distinct device_id)  machines
from maintenance_schedule join login using (login_id)
where
     device_id in (select device_id from device where removed_date is null)
     and maintenance_schedule.removed_date is null
group by login_id;