Subversion Repositories computer_asset_manager_v2

Rev

Rev 48 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 48 Rev 53
Line 35... Line 35...
35 
   join camp.site using (site_id)
 35 
   join camp.site using (site_id)
36 
   join camp.client using (client_id)
 36 
   join camp.client using (client_id)
37 
   join camp.device_type using (device_type_id)
 37 
   join camp.device_type using (device_type_id)
38 
where
 38 
where
39 
   device_type.show_as_system = 'Y'
 39 
   device_type.show_as_system = 'Y'
40 
   and device.removed_date is null
 40 
/*   and device.removed_date is null
41 
   and site.removed_date is null
 41 
   and site.removed_date is null
42 
   and client.removed_date is null
 42 
   and client.removed_date is null
- 
 
 43 
*/
43 
;
 44 
;
44 
 
 45 
 
45 
 
 46 
 
46 
/*
 47 
/*
47 
  uuid and serial number are stored A) in the table and B) in the attrib_device table.
 48 
  uuid and serial number are stored A) in the table and B) in the attrib_device table.