Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
82 rodolico 1 
update
2 
   maintenance_schedule
3 
set
4 
   login_id = 6
5 
where
6 
   removed_date is null
7 
   and device_id in (
8 
      select
9 
         device_id
10 
      from
11 
         device
12 
      where
13 
         removed_date is null
14 
         and site_id in ( 16,38 )
15 
         and device_type_id in (
16 
            select
17 
               device_type_id
18 
            from
19 
               device_type
20 
            where
21 
               show_as_system = 'Y'
22 
            )
23 
      )