Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
82 rodolico 1 
/*
2 
   changes an entire client to have maintenance performed
3 
   by a specific technician
4 
   change
5 
      login_id to technician
6 
      client.name to client name
7 
*/
8 
 
9 
update maintenance_schedule
10 
   set login_id = 6
11 
   where
12 
      removed_date is null
13 
      and device_id in (
14 
         select
15 
            distinct( device.device_id )
16 
         from
17 
            device
18 
            join device_type using (device_type_id)
19 
            join site using (site_id)
20 
            join client using (client_id)
21 
         where
22 
            client.name like '%primary%'
23 
            and device_type.show_as_system = 'Y'
24 
         );