Subversion Repositories computer_asset_manager_v1

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
15 rodolico 1 
select
2 
   network_id,
3 
   network.device_id,
4 
   device.name 'Server',
5 
   interface,
6 
   address,
7 
   netmask,
8 
   mac
9 
from
10 
   network join device using (device_id)
11 
where
12 
   network.removed_date is null
13 
   and device.removed_date is null
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%'
23 
order by
24 
   device.name,
25 
   interface
26 
;