Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rodolico 1 
/* get maintenance tasks and machines per user */
2 
select login.email, count(*) tasks,count(distinct device_id)  machines
3 
from maintenance_schedule join login using (login_id)
4 
where
5 
     device_id in (select device_id from device where removed_date is null)
6 
     and maintenance_schedule.removed_date is null
7 
group by login_id;