Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rodolico 1 
select
2 
   login.email,
3 
   count(*) tasks,
4 
   device.name
5 
from
6 
   maintenance_schedule
7 
   join login using (login_id)
8 
   join device using (device_id)
9 
where
10 
   device_id in (select device_id from device where removed_date is null)
11 
   and maintenance_schedule.removed_date is null
12 
group by
13 
   login_id,
14 
   device.name
15 
order by
16 
   login.email,
17 
   device.name;