Subversion Repositories computer_asset_manager_v1

select 
   network_id,
   network.device_id,
   device.name 'Server',
   interface,
   address,
   netmask,
   mac
from
   network join device using (device_id)
where
   network.removed_date is null
   and device.removed_date is null
   and network.interface not in ('lo')
   and 
   ( 
      device.site_id = 14
      or device.name in ( 'dfwpowder-xen.dfwpowdercoatings.local', 'xen.vanduzen.com', 'mail.keenemachinery.com', 'web.nvcreativetechnology.com', 'web2.vanduzen.com' )
      or device.part_of in (select device_id from device where device.name in ( 'dfwpowder-xen.dfwpowdercoatings.local', 'xen.vanduzen.com' ) )
   )
   and address is not null
   and interface not like 'tun%'
order by
   device.name,
   interface
;