Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 31 Rev 75
Line 10... Line 10...
10 
   network join device using (device_id)
 10 
   network join device using (device_id)
11 
where
 11 
where
12 
   network.removed_date is null
 12 
   network.removed_date is null
13 
   and device.removed_date is null
 13 
   and device.removed_date is null
14 
   and network.interface not in ('lo')
 14 
   and network.interface not in ('lo')
15 
   and
- 
 
16 
   (
- 
 
17 
      device.site_id = 14
 - 
 
18 
      or device.name in ( 'dfwpowder-xen.dfwpowdercoatings.local', 'xen.vanduzen.com', 'mail.keenemachinery.com', 'web.nvcreativetechnology.com', 'web2.vanduzen.com' )
 - 
 
19 
      or device.part_of in (select device_id from device where device.name in ( 'dfwpowder-xen.dfwpowdercoatings.local', 'xen.vanduzen.com' ) )
 - 
 
20 
   )
 - 
 
21 
   and address is not null
 - 
 
22 
   and interface not like 'tun%'
 15 
   and interface not like 'tun%'
23 
order by
 16 
order by
24 
   device.name,
 17 
   device.name,
25 
   interface
 18 
   interface
26 
;
 19 
;