Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rodolico 1 
select
2 
   distinct(device.name),
3 
   site.name,
4 
   client.name
5 
from
6 
   maintenance_schedule join device using (device_id)
7 
   join site using (site_id)
8 
   join client using (client_id)
9 
where
10 
   maintenance_schedule.removed_date is null
11 
   and device.removed_date is null
12 
order by
13 
   client.name,
14 
   site.name,
15 
   device.name;