Subversion Repositories computer_asset_manager_v1

Rev

Rev 31 | Details | Compare with Previous | Last modification | View Log | RSS feed

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