Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

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